What is database offline?

Question

I've had to do this before. Sometimes a nasty bug is found in your app that, even though not malicious, will still corrupt data in your database. Taking the .

What is an offline database?

Definitions. A local working copy of a remote shared database in which you can make changes while you are disconnected.

What happens if I take database offline?

Taking the database offline is a quick way to stop the bleeding until you get the bug identified. You can then bring it back online to assess the damage within the database.

How do I get my database online from offline mode?

The name of the database we're going to bring online is MyDatabase, that we can see the database name is appended with '(Offline)'.1Expand server dropdown.2Expand Databases dropdown.3Right click on database name, MyDatabase.4Tasks (Take Offline is grayed out)5Bring Online.

How do I stop my database offline?

This method was easy enough:1Right-click the database -> Properties -> Options.2Set Database Read-Only to True.3Click 'Yes' at the dialog warning SQL Server will close all connections to the database.4Re-open Options and turn read-only back off.5Now try renaming the database or taking it offline.

Expert · Answer