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
After that, I added some more data into a new table and continued with making a
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.