Backup and Restore SQL Database using SSMS

Getting Backup of SQL Server database is one of the very important task before doing any critical change in database to avoid data loss. It ensures the 100% data availability. In this article, I am going to write steps to get Backup and Restore SQL Server Database using SQL Server Management Studio (SSMS). SQL Server Management Studio is the Microsoft’s support to manage to SQL Server platform. If you don’t have this, you can download it from this link: http://www.microsoft.com/en-in/download/details.aspx?id=7593

Steps to get Backup of SQL Server Database using SSMS

1. Connect SQL Server Management Studio by entering SQL Server details.

Backup and Restore SQL Server Database using SSMS

2. Expand the node Databases, right-click on the database which you want to backup. Select Back Up… option under Tasks menu (Tasks/Back Up…).

3. Remove default SQL backup destination by clicking Remove button and click Add to add new Backup destination.

4. Click Add (empty) button, and select new SQL Database Backup destination, click OK to add new SQL Backup destination.

5. Finally, click OK to complete SQL Database Backup, you will see the message The backup of database “MorganDB’ completed successfully on completion of backup process.