SQLTeam.com | Weblogs | Forums

Restore database in sql server



when I try to restore database with full backup and differential, i got error:

System.Data.SqlClient.SqlError: This differential backup cannot be restored because the database has not been restored to the correct earlier state. (Microsoft.SqlServer.Smo)

first i restore full backup with norecovery, it success. but after that i differential it error.

Please help to solve this.


you are sure those backup are the correct FULL and DIFFERENTIAL and there aren't any FULL backup done in between ?


i get them from other person.
so it mean if there is full backup between these full backup and differential, it makes error like this?


yes. You should restore the LAST FULL backup done before the DIFFERENTIAL first then follow by the DIFFERENTIAL backup


thanks for your reply. :smile: