How to Restore MS SQL Server Database Backup File

May 24, 2017 / MS SQL

Follow the steps mentioned below to restore a database from a backup file.

  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.“.

Tagged:

Related Articles