Pages

Saturday, September 21, 2013

SQL SERVER – 2005 Take Off Line or Detach Database | Journey to SQL Authority with Pinal Dave

EXEC sp_dboption N'mydb', N'offline', N'true' OR ALTER DATABASE [mydb] SET OFFLINE WITH ROLLBACK AFTER 30 SECONDS OR ALTER DATABASE [mydb] SET OFFLINE WITH ROLLBACK IMMEDIATE Using the alter database statement (SQL Server 2k and beyond) is the preferred method. The rollback after statement will force currently executing statements to rollback after N seconds. The default… Continue Reading...

Source: SQL SERVER – 2005 Take Off Line or Detach Database | Journey to SQL Authority with Pinal Dave