Restore a MSSQL BAK Backup

Restore a MSSQL BAK Backup

To restore a MSSQL BAK database backup, do the following steps:

  1. Open Management Studio and connect to the database server.
    1. Right-Click on Databases
    2. Select Restore Database...
  2. In the dialog that appears:
    1. Select     Device
    2. Click the ... button:
  3. In the dialog:
    1. Select     File
    2. Click Add
  4. In the dialog that appears:
    1. Select your BAK database backup
    2. Click     OK
  5. Click OK to confirm your backup device selection:
  6. Back on the Restore Database screen, give the database a descriptive name.
  7. Lastly:
    1. Click on     Files
    2. Select Relocate all files to folder
    3. Click OK
  8. The database will now be restored and visible through Management Studio

 

Important Note

If restoring the same database multiple times or if you have two different databases that have had the same name, replace the name of the database in the "Restore As" file name with the name of the new destination database. 

 

 

 


    • Related Articles

    • Create a MSSQL BAK Backup

      To create a BAK backup, do the following steps: 1. Shrink the Database (Optional) Open Management Studio and connect to the database server. Change the Recovery Model to Simple: 1. Right click on the database you wish to backup and select Properties. ...

    • Restore a MSSQL BACPAC Backup

      BACPAC files are a specialized set of SQL Scripts that can be restored into Microsoft SQL Server using Management Studio. To restore a BACPAC database, do the following steps. Open Management Studio and connect to the database server. Right-click on ...

    • Restore a POSTGRES Backup

      Once someone sends you a backup created by following these instructions, you can restore it by following the steps below. Navigate to the location your TAR file is saved at. Extract the TAR File A TAR file is similar to a ZIP file. Using 7Zip, open ...

    • Create a MSSQL BACPAC Backup

      To create a BACPAC backup, do the following steps: Open Management Studio and connect to the database server. Right click on the database you wish to backup and select Tasks > Export Data-tier Application... In the dialog that appears click "Next >" ...

    • Repair a corrupt MSSQL database

      For law firms with premises based systems like Time Matters you may run into situations where the database has not been maintained and has become inconsistent. This can prevent your ability to create a backup from which you can migrate the customer ...