Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Cant Restore Differential Backup Expand / Collapse
Posted Tuesday, April 2, 2013 8:52 AM



Group: General Forum Members
Last Login: Yesterday @ 9:43 AM
Points: 5,069, Visits: 4,846
I restored a Full Backup from 12:30 AM this morning and I specified WITH NORECOVERY.

Then I attempted to restore a differential Backup that I made at 10:30 AM and I specified WITH RECOVERY.

However I get the following error as if I had specified recovery on the full backup:

Msg 3136, Level 16, State 1, Line 1
This differential backup cannot be restored because the database has not been restored to the correct earlier state.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Any ideas would be greatly appreciated?

For better, quicker answers on T-SQL questions, click on the following...

For better answers on performance questions, click on the following...

Post #1437943
Posted Tuesday, April 2, 2013 9:09 AM



Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
There was another full backup taken (without the copy_only option) sometime between the full that you took and the diff that you took.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1437954
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse