April 29, 2009 at 9:29 pm
hi everybody.
i had restore fully database in sql 2005 with norecovery and it done.but when i restore the differential the error show it like this.
System.Data.sqlClient.SqlError.This Diffential backup cannot be restore because the database has not be restored to the correct earlier state. (Microsoft.sqlServer.Smo)
could anyone help with this problem.
April 29, 2009 at 9:39 pm
The quick and easy answer is that the full backup you restored was not the base full backup for that particular differential backup.
When I have to restore a database, usually a copy of production to development, I use the GUI tool to select the appropriate files and then have it script it for me and then modify that script as appropriate. Saves me the time and effort of typing out the entire restore script by hand.
April 29, 2009 at 9:54 pm
so can you tell me how to do it lynnn. thanks
April 30, 2009 at 2:27 am
What you need to restore there is to find the full backup that the diff you're using is based on. A diff is based on the last full backup that was made before it was made.
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply