SQLTeam.com | Weblogs | Forums

Restore database in sql server


#1

HI

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.


#2

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


#3

No
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?


#4

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


#5

OK
thanks for your reply. :smile: