Archive

Posts Tagged ‘restore database’

MSSQL Restore locked database

October 18th, 2011 No comments

Below is a short snippet that will allow you to restore your database by putting it in single user mode.
After restoring (if without errors) it will be in multi user mode again. If it is not you can still run the ‘alter database DATABASE_NAME set multi_user’ command to put it back in original mode.

USE master;
 
ALTER DATABASE [DATABASE_NAME] SET single_user WITH ROLLBACK immediate;
 
restore DATABASE [DATABASE_NAME] FROM disk = 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\YOUR_AWESOME_BACKUP.bak';
Categories: SQL Tags: , ,