Loading ...

How to take a db offline via script | CodeAsp.Net

How to take a db offline via script

 /5
0 (0votes)

One person asked me today on how to take a db offline via script. Below is the script for doing the same purpose:

ALTER DATABASE <DBName> SET OFFLINE WITH
ROLLBACK IMMEDIATE

 The ROLLBACK statement above will force the currently executing statements to rollback immediately. 

Comments (no comments yet)

Top Posts