Answers

Question and Answer:

  Home  MS SQL Server

⟩ How to set a database state to OFFLINE in MS SQL Server?

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 "GlobalGuideLine" offline:

ALTER DATABASE GlobalGuideLine SET OFFLINE

GO

SELECT name, state_desc from sys.databases

GO

name state_desc

master ONLINE

tempdb ONLINE

model ONLINE

msdb ONLINE

GlobalGuideLine OFFLINE

USE GlobalGuideLine

GO

Msg 942, Level 14, State 4, Line 1

Database 'GlobalGuideLine' cannot be opened because

it is offline.

 174 views

More Questions for you: