How to restore MS SQL server database backup file May 24, 2017

May 24, 2017 / MS SQL

In this article, you will discover how to restore an MS SQL Server database backup file.

Follow the steps:

  1. Open your MS SQL Server Management Studio and connect to your database.
  2. Select the database and Right-click >> Tasks >> Restore >> Database.
    object explorer
  3. The “Restore Database” window will display. Select “From device” mentioned below the “Source for restore” and click the button in front of that to specify the file location.
    script
  4. Select the option “Backup media as File” and click on the Add button to add the backup file location.
    general
  5. Select the backup file you want to restore and click the OK button.locale

That’s it! Your SQL Server database has been restored successfully, and you will see the confirmation message: “The restoration of database ‘SQLDatabaseName’ completed successfully.”

Spread the love
Tagged:

Related Articles