Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zhillma
Starting Member
2 Posts |
 Posted - 2011-07-24 : 06:57:56
|
| Hi,I'm trying to restore my database to a specific point in time but under another name. This involves a full backup and 4 tran logs. The backup restores fine but the tran logs error with the message that states the last LSN in the tran log is too early for this backup and a much more recent LSN can be restored. I have checked the LSN's in the files and all seems fine. It Has anyone come across this? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-24 : 08:20:33
|
| Try skipping that log backup and restoring the next. It's telling you that all the transactions in that log backup are already in the DB.--Gail ShawSQL Server MVP |
 |
|
|
zhillma
Starting Member
2 Posts |
Posted - 2011-07-24 : 19:37:16
|
| That's what so odd, the LSN's in the file headers seem to indicate that the transaction log is not in the database being restored, but WOULD be in the database whose backups i'm using (i.e. the original one which is now several days newer). Could it be comparing LSN's with the wrong database? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Point in time restore