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 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:
    Database
  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:
    restore database
  4. Select the option “Backup media as File” and click on the Add button to add the backup file location.
    specify backup
  5. Select the backup file you want to restore and click the OK button:
    locate backup file

That’s it!  Now you have restored your SQL server database successfully with confirmation message “The restoration of database ‘SQLDatabaseName’ completed successfully.“.

Spread the love
Tagged:

Related Articles