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 and Restore SQL Server Database in SSMS

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

Kailash Chandra Behera

An IT Professional with 12 years experience in development life cycle in windows, service and Web based application using Microsoft.Net technologies. Proven record of developing all phases of projects in Microsoft.Net technology from initiation to closure aligning with the company's Business objectives to drive process improvements, competitive advantage and bottom-line gains. -> Good exposure of independently working and developing multiple projects ->Committed to efficient and effective development of projects in a fast-paced and deadline driver environment. Skill :- Develop and design projects in various technologies of Microsoft Technology. Total IT Experience- 13+

Previous Post Next Post

نموذج الاتصال