Some data went missing from one of my databases so I am trying to restore a backup to see if I can get it back.
I am logged in as an admin and using SSMS and clicking restore database. Then I select Device and choose file and choose the .bak file I want to import. I change the Destination to the new name I want, check that the files are set to restore as that new name and then click OK.
However, it keeps failing.
Restore of database 'TestRestore' failed
Exclusive access could not be obtained because the database is in use.
Why cant I restore this file to a new databse?