Backup and Restore SQL Server Database in SSMS

This blog post will help you to take a backup of database and restore the database of SQL Server using Microsoft SQL Server Management Studio (SSMS). We will discuss the steps in detail which will help you to take a backup and restore the database of the SQL server without any complexity.

Backup Database SQL Server

The following steps will help you to take a backup of database of SQL Server and save that backup database file in a drive.

• Open the  SQL Server Management Studio (SSMS) and connect to your SQL Server instance
• Expand the Databases node in Object Explorer.
• Right-click the database, hover over Tasks, and select Back up....
• Under Destination, confirm that the path for your backup is correct.
  • Select the existing path exists in the path field and click on Remove to remove it, and then Click on Add button.
  • The Backup Destination windows will be opened, click on the ellipses (...) button.
  • The Locate Database Files window will be opened, Find the folder or drive where you want to save the backup file.
  • In the File Name field, enter the backup file name. Don’t forgot to mention .bak with filename as suffix.
• Click on OK to close the Locate Database Files window.
• On the Select Backup Destination window click on the OK button.
• Again, click on the OK button of Backup database window.
• You will see the progress in the Progress section.

Restore Database Sql Server

• Open the SQL Server Management Studio (SSMS) and connect to your SQL Server instance.
• Expand the Databases node in Object Explorer.
• Right-click the Database Name in Object Explorer, hover over tasks, Restore then click on Database....
• The Restore Database window will be opened.
• Select Device, and then click on the ellipses (...) to locate your backup file.
• The Select Backup Devices window will be opened.
• Click on Add and navigate to where your .bak file is located.
• if the .bak file is not appearing then in the Locate Backup File window, select “All File (*) as filter value.
• Select the backup file and then select OK.
• Click on the Options in Restore Database Window
• Select Overwrite the existing database (WITH REPLACE) in restore option section
• Select Close existing connection to destination database in Server connections section, if it exists.
• Select OK to close the Select backup devices dialog box.
• Select OK to restore the backup of your database.

Summary

I hope the steps of backup database and restore database will help you to take backup and restore database of SQL server in SSMS.

Thanks