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…).

Backup and Restore SQL Server Database using SSMS

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

Backup SQL Server Database using SSMS

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

Backup SQL Server Database using SSMS

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.

Backup and Restore SQL Server Database using SSMS

Steps to Restore SQL Server Database using SSMS

1. Right-click on Databases node and select Restore Database…

Backup and Restore SQL Server Database using SSMS

2. Type new database name and select the option From Device for restore database source, click Add (empty) button to select Database Backup file.

Restore SQL Server Database using SSMS

3. Click Add button, select Files of type as All Files, then select the backup file and click OK.

Restore SQL Server Database using SSMS

4. Select Restore check box and click OK to complete Restore SQL Database process.

Restore SQL Server Database using SSMS

5. Now, you can see the restored database by expanding Databases node.

Backup and Restore SQL Server Database using SSMS
Advertisement

Leave a Comment