Kailash's Blogs

Backup and Restore SQL Server Database in SSMS

Kailash Chandra Behera | Wednesday, September 13, 2023
Kailash's Blogs

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


No comments: