I'm trying to restore a differential backup of a test database, but I'm getting a error saying:
What I have done is created a test database, called "tdb"
, where I added some data in a new table, changed the recovery model of the database to SIMPLE
and then created a FULL Backup
.
After that, I added some more data into a new table and continued with making a differential backup
.
When restoring the database I restored the full backup first, chosing the Overwrite existing database (WITH REPLACE)
option from SSMS, which worked correctly.
Then when trying to do the same thing with the differential backup file, I get the above error.
I've looked at the Microsoft documentation as well and I've followed the same steps mentioned there, but I don't see what I've done wrong. Any help is appreciated.