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, 2503🔥, 0💬
Popular Posts:
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...