adamvduke · October 20, 2010 01:33
diff --git a/ForceRestoreFromBackupFile.sql b/ForceRestoreFromBackupFile.sql
 /* Forces exclusive access to a database allowing a restore and subsequently restores the database from a backup file. This will interrupt any existing connections and rollback any in progress transactions. Use at your own risk. */

 ALTER DATABASE [database_name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE 
 RESTORE DATABASE [database_name] 
 FROM  DISK = N'C:\path\to\backup\backupfile.bak' 
 WITH  FILE = 1,  KEEP_REPLICATION,  NOUNLOAD,  REPLACE,  STATS = 10
 GO
	/* Forces exclusive access to a database allowing a restore and subsequently restores the database from a backup file. This will interrupt any existing connections and rollback any in progress transactions. Use at your own risk. */

	ALTER DATABASE [database_name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
	RESTORE DATABASE [database_name]
	FROM DISK = N'C:\path\to\backup\backupfile.bak'
	WITH FILE = 1, KEEP_REPLICATION, NOUNLOAD, REPLACE, STATS = 10
	GO