April 2, 2013 at 8:52 am
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...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 2, 2013 at 9:09 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply