«
»


Take a MSSQL database offline and back online with TSQL

by Jon Hibbins on 5 August 2008
Filed under: Code, Database, MSSQL2005, Software Development, SQL Server, TSQL

Take a database offline with TSQL:

– Kill All Other Users Processes And Set The Database To Single User Mode
ALTER DATABASE AdventureWorks
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
– Take Offline
EXEC sp_dboption ‘AdventureWorks’, ‘offline’, ‘TRUE’

And restoring the database back to online with TSQL:

– Allow Users Back In By Setting Multi User Mode On
ALTER DATABASE AdventureWorks SET MULTI_USER
– Bring Back Online
EXEC sp_dboption ‘AdventureWorks’, ‘offline’, ‘FALSE’

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Take a MSSQL database offline and back online with TSQL”

  1. User links about "mssql" on iLinkShare Says:
    September 22nd, 2008 at 12:18 am

    [...] | user-saved public links | iLinkShare 1 votesTake a MSSQL database offline and back online with TSQL>> saved by MostExcellent1 2 days ago4 votesMSSQL Injection Virus & Managed Hosting>> saved by [...]

Leave a Reply