Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Failure Restoring Differential Backup Expand / Collapse
Author
Message
Posted Friday, September 20, 2013 9:59 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:57 PM
Points: 1,141, Visits: 346
I have an issue with my SQL 2012 database server and restoring a full backup (norecovery) then applying a differential backup. The error message is that there is a break in the LSN chain. The First LSN of the full backup is the same as the Full LSN of the differential backup so I'm confident there is not a break in the backup chain. I am restoring a Production Backup to our DEV Server, so the issue is not currently critical, but I don't feel confident that I could recover to a point in time if I had a Production failure.

Does anyone have knowledge of a Hot Fix or work around?
Post #1496945
Posted Friday, September 20, 2013 4:11 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 1:24 PM
Points: 805, Visits: 722
Could you post the exact error message?

How do deduce that the first LSNs are the same?


Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1497072
Posted Monday, September 23, 2013 6:53 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:57 PM
Points: 1,141, Visits: 346
The header file on each backup contains the LSN numbers. Querying the msdb database also produces matching LSN numbers.
Post #1497364
Posted Wednesday, September 25, 2013 5:55 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 1:24 PM
Points: 805, Visits: 722
I am travelling, and don't have the time to research this further. Anyone else who can step in?

Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1498276
Posted Wednesday, September 25, 2013 6:10 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 6:31 AM
Points: 1,191, Visits: 9,882
Could you post the full error message?

There's a connect item related to restoring a SQL 2008 database using SSMS 2012 GUI, which posts an erroneous error message about LSN chain breaks, are you hitting that scenario?

http://connect.microsoft.com/SQLServer/feedback/details/755813/sql-server-management-studio-2012-errors-when-doing-restore-to-sql-2008

It should still work through T-SQL restore commands if you're hitting that
Post #1498283
Posted Wednesday, September 25, 2013 6:42 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:57 PM
Points: 1,141, Visits: 346
I was able to successfully restore a smaller database (12GB). I'll have to wait to try this larger one (about 300GB) when we have to do another refresh. I can't really do it now.
Post #1498303
Posted Wednesday, September 25, 2013 7:34 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:57 PM
Points: 1,141, Visits: 346
So here's what did and did not work:


Didn't work:

1. Add full backup

2. Restore with NoRecovery

3. Add differential backup


What did work:

1. Add full backup

2. Add differential backup

3. Restore With Recovery and prompt for each file.
Post #1498354
Posted Sunday, September 29, 2013 4:15 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 1:24 PM
Points: 805, Visits: 722
So that is the problem: you are using the UI, instead of using T-SQL commands directly. At very least if you use the UI, and things don't work out, you should use the Script button to see what SSMS intend to do.



Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1499789
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse