How To Restore a Microsoft SQL Database Backup Using SQL Server Management Studio?

If you downloaded the mssql database backup from Plesk Control panel and you want to Restore a Microsoft SQL Database Backup Using SQL Server Management Studio

To Restore a Microsoft SQL Database Backup Using SQL Server Management Studio.

  1. Open SQL Server Management Studio and Connect to the SQL Server you want to restore the database to.
  2. Once you Connected to the SQL server, right click on the Databases folder and select ‘Restore Database’.
  3. First Select From Device then Click the ellipses button next to From device under the Source for restore section.
  4. Set File as the backup media and then click Add.

  5. Browse to the SQL backup (.BAK) file you want to restore and Click Ok.
  6. Then Click Ok.
  7. In the Restore Database dialog, type or select the name of the database you want this backup restored to.
    1. If you select an existing database, it will be replaced with the data from the backup.
    2. If you type a database name which does not currently exist in your SQL Server installation, it will be created.
  8. Next, select the restore point you want to use. Since a SQL backup file can hold multiple backups you may see more than one restore point listed.
  9. Click OK. You will get database successful restore Message.
  10. Once your restore options are set, click Ok.

Related Articles