46
VPS Hosting Experience / How to Backup MSSQL Database From SQL Server Management Studio?
« on: December 24, 2018, 01:11:58 AM »
To take MS SQL database backup, first, you need to connect to MS SQL Server through SQL Server Management Studio.
You can also refer to the following article to take a backup of the MSSQL database.
https://manage.accuwebhosting.com/knowledgebase/2197/How-to-Backup-MSSQL-Database-from-SQL-Server-Management-Studio.html
- Once you are connected to Microsoft SQL Server Database Engine, at the left-hand side in Object Explorer pane, click the SQL server name to expand the server tree.
- Expand Databases and right-click on the database, select Tasks and click Backup. This will open up Backup-database window.
- In the Backup type list box select Full, for Backup component, click Database.
- Enter a name for the backup set or accept the suggested default backup set name.
- Enter Description of the backup set (optional).
- Choose the type of backup destination to Disk and click Add. Now select the destination where you want to store the database.
- Once you select the backup destination, click Ok.
- Make sure that your chosen backup destination is listed in destination box and click Ok.
- Navigate to backup destination and verify the backup file.
- That’s it.
You can also refer to the following article to take a backup of the MSSQL database.
https://manage.accuwebhosting.com/knowledgebase/2197/How-to-Backup-MSSQL-Database-from-SQL-Server-Management-Studio.html