How to Backup MSSQL Database From SQL Server Management Studio?

[AccuWebhosting]

To take MS SQL database backup, first, you need to connect to MS SQL Server through SQL Server Management Studio.

• 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

[supportwala]

We at Support Wala IT Services LLP has been at the forefront of providing quality managed technical services to various companies for more than 10 years. Our areas of expertise include dedicated technical support, high availability and high-load projects implementation, infrastructure management as well as server management.

Contact us at Supportwala.net for any issue related to Servers.