How to take a database offline

Here is one way to take a database offline. This will prevent any reads, writes or even a connection to it (including any objects within it):

You should get these results below in your output window:

SET-DATABASE-OFFLINE

Views – 2425

Leave a Reply