SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Backup restore sequence help
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Hommer
Aged Yak Warrior

794 Posts

Posted - 05/08/2013 :  09:11:45  Show Profile  Reply with Quote
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 1
1) 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 PM
5) 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

794 Posts

Posted - 05/08/2013 :  10:45:40  Show Profile  Reply with Quote
It turned out the server knew which is the right one.

restore log 3) gave me this:
Msg 4326, Level 16, State 1, Line 1
The 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 1
RESTORE 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 1
1) 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 PM
5) 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!


Edited by - Hommer on 05/08/2013 10:47:33
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2079 Posts

Posted - 05/08/2013 :  12:27:36  Show Profile  Visit jackv's Homepage  Reply with Quote
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 restore
http://www.sqlserver-dba.com/2012/06/display-sql-backup-history-for-a-single-database.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000