SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Failure Restoring Differential Backup


Failure Restoring Differential Backup

Author
Message
cathy.baker
cathy.baker
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1256 Visits: 396
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?
Erland Sommarskog
Erland Sommarskog
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2101 Visits: 872
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
cathy.baker
cathy.baker
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1256 Visits: 396
The header file on each backup contains the LSN numbers. Querying the msdb database also produces matching LSN numbers.
Erland Sommarskog
Erland Sommarskog
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2101 Visits: 872
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
HowardW
HowardW
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2233 Visits: 9892
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
cathy.baker
cathy.baker
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1256 Visits: 396
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.
cathy.baker
cathy.baker
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1256 Visits: 396
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.
Erland Sommarskog
Erland Sommarskog
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2101 Visits: 872
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search