Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - OFFLINE - Taking a database offline

By: FYIcenter.com

(Continued from previous topic...)

How to set a database state to OFFLINE?

If you want to move database physical files, you should take the database offline by using the "ALTER DATABASE" statement with the following syntax:

ALTER DATABASE database_name SET OFFLINE

The following tutorial example will bring "FyiCenterComData" offline:

ALTER DATABASE FyiCenterComData SET OFFLINE
GO

SELECT name, state_desc from sys.databases
GO
name               state_desc
master             ONLINE
tempdb             ONLINE
model              ONLINE
msdb               ONLINE
FyiCenterComData   OFFLINE

USE FyiCenterComData
GO
Msg 942, Level 14, State 4, Line 1
Database 'FyiCenterComData' cannot be opened because 
   it is offline.

(Continued on next topic...)

1. What is a database?
2. What is the simplest way to create a new database?
3. How to set the current database?
4. How to delete a database?
5. Why I am getting this error when dropping a database?
6. How to get a list all databases on the SQL server?
7. Where is my database stored on the hard disk?
8. How to create database with physical files specified?
9. How to rename databases?
10. Why I am getting this error when renaming a database?
11. What are database states?
12. How to set a database state to OFFLINE?
13. How to move database physical files?
14. How to set database to be READ_ONLY?
15. How to set database to be SINGLE_USER?
16. What are system databases?