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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2013-05-08 : 09:11:45
|
| Hi,I need your advice on a Backup restore sequence case.This is for restoring full and transaction backup from primary server to mirror server for sql2008 R2 mirroring. The mirroring operation got suspended for a while so they are out of synched.I have these backup files on server 11) 7:30 PM Transaction log backup 2) 8:00 PM Full backup start 3) 8:30 PM Transaction log backup 4) 9:00 PM full backup completed, .bak file time stamp at 8:57 PM5) 9:30 PM Transaction log backup My question is when I restore to server2, what comes after the full back up, the 3) or the 5)? Thanks! |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2013-05-08 : 10:45:40
|
It turned out the server knew which is the right one.restore log 3) gave me this:Msg 4326, Level 16, State 1, Line 1The log in this backup set terminates at LSN 264985000001134600001, which is too early to apply to the database. A more recent log backup that includes LSN 264985000001151600001 can be restored.Msg 3013, Level 16, State 1, Line 1RESTORE LOG is terminating abnormally.quote:
Originally posted by Hommer
Hi,I need your advice on a Backup restore sequence case.This is for restoring full and transaction backup from primary server to mirror server for sql2008 R2 mirroring. The mirroring operation got suspended for a while so they are out of synched.I have these backup files on server 11) 7:30 PM Transaction log backup 2) 8:00 PM Full backup start 3) 8:30 PM Transaction log backup 4) 9:00 PM full backup completed, .bak file time stamp at 8:57 PM5) 9:30 PM Transaction log backup My question is when I restore to server2, what comes after the full back up, the 3) or the 5)? Thanks!
|
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-05-08 : 12:27:36
|
| Could you check if it meant the FULL BACKUP restore. I'm assuming you're restoring the FULL backup started and completed with steps 2 & 4. In terms of restore , the next step would be 5 . As the FULL BACKUP will contain all transactions commited during the full backup Use this query to identify the first and last LSN of the various backups you've taken , and use as a guide what to restorehttp://www.sqlserver-dba.com/2012/06/display-sql-backup-history-for-a-single-database.htmlJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
|
|
Backup restore sequence help