USE masterGOALTER DATABASE <mydatabase>SET SINGLE_USER--This rolls back all uncommitted transactions in the db.WITH ROLLBACK IMMEDIATEGORESTORE DATABASE <mydatabase> FILE = N'mydatabase' FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\... WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10GO ......