Wednesday, March 21, 2012

Does offline database come back online when server is restarted?

If you take a database offline to prevent users from accessing it, and then restart the server, will the database be back online when the server starts up?

If so, is there an option to prevent this from happening so that a database taken offline will remain offline until it is manually put online again by an administrator?

The database state is kept in the master database, and is persistent across shutdowns as long as the database is not detached.

A database which is set OFFLINE will not come ONLINE until an administrator explicitly sets it back ONLINE.

No comments:

Post a Comment