Restore database in sql server

SQL Server Administration
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 ?

1 Like
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

2 Likes
5

OK
thanks for your reply. :smile: