When I try to restore my database with
RESTORE DATABASE MyDatabase FROM DISK = '\path\to\my\backup.bak' WITH REPLACE, RECOVERY
Exclusive access could not be obtained because the database is in use.
After some googling I tried this instead:
ALTER DATABASE MyDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO RESTORE DATABASE MyDatabase FROM DISK = '\path\to\my\backup.bak' WITH REPLACE, RECOVERY GO
However, this seemed to take forever and when I eventually cancelled the command it told me that
Nonqualified transactions are being rolled back. Estimated rollback completion: 0%.
The message repeated multiple times and the progress was always 0%.
I'm not a DBA --sadly my company does not employ any-- and I have no clue where to go from here.