How to take MSSQL database offline or bring it online
Sometimes, you come across to a situations when you are required to physically move the database files. Online databases will not allow you such moving operations on “online” status therefore, you will require to take your database offline to accomplish it. You can do it from SQL Server Management Studio interface as mentioned below:
Steps to Take MS SQL Database Offline
1. Login into your SQL Server Management Studio.
2. Expand Databases option and locate the database that you wish to take offline.
3. Right click the database and select Tasks >> Take Offline.
4. Once this is done, it will show you a message as below:
Steps to Bring MS SQL Database Online:
1. Once you are done with transferring the database files, you will require to bring the database online again.
2. For that, again expand the Databases option and locate your offline database.
3. Right click the database and select Tasks >> Bring Online.
4. Once the process is done, it will show you a message as below:
Related Articles
How to take MSSQL database backup from SolidCP
Steps to follow to take MSSQL database backup in SolidCP Login to SolidCP. Once you are logged into SolidCP, click on All Customers link. In the next screen, you will see the list of all created users. If you have not created any user yet, you'll see ...Backup and restore MySQL database with Plesk
Backup and restore MySQL database with Plesk Description: In Plesk, database dumps are created in the SQL format and saved as ZIP archives. If you need to create a dump in another format or to set custom settings for a dump, use the native ...Take Full backup of MS-SQL database using management studio
To take the full backup of MS-SQL database, please follow the below steps 1. Open SQL Server Management Studio and connect to the appropriate instance of Microsoft SQL Server Database Engine in Object Explorer. 2. Expand Databases node and then right ...Plesk database missing in subscription
Check and Move database between different subscription Issue: Database is not showing under the original Subscription from Plesk Panel Observation: With the following command it is found under which subscription the database is currently exist. ( ...How to take MySQL database backup from SolidCP
Steps to follow to backup MySQL database in SolidCP Login to SolidCP. Once you are logged into SolidCP, click on All Customers link. In the next screen, you will see the list of all created users. If you have not created any user yet, you'll see the ...