Collections:
OFFLINE - Taking a database offline in SQL Server
How to set a database state to OFFLINE in SQL Server?
✍: FYIcenter.com
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.
⇒ Moving Database Physical Files to New Locations in SQL Server
⇐ ONLINE/OFFLINE - Database States in SQL Server
2016-11-20, 2367🔥, 0💬
Popular Posts:
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...