How to Manually Restore an MSSQL Database in Management Studio

If you need to manually restore an SQL Database in Management Studio you can follow the instructions below for the version of SQL Server running on your server.

Please note:  This can not be done remotely, If you are a shared hosting customer you will need to contact support to have this performed for you.
SQL Server 2012:

  1. Log onto SQL Server Management Studio:
  2. Navigate to the database you wish to restore.
  3. Right Click > Tasks > Restore > Database.
  4. Once on the General tab set the source to Device > Select Backup Device > Add > Navigate to the .bak file you’re restoring to.
  5. Ensure The Destination Database is the correct one.
  6. Select the Options tab.
  7. Check Overwrite the existing database (WITH REPLACE) and Close existing connections to destination database.
  8. Uncheck Take Tail-Log Backup Before Restore.
  9. Click OK.
SQL 2008:
  1. Log into SQL Server Management Studio.
  2. Navigate to the database you wish to restore.
  3. Right click > Tasks > Restore > Database.
  4. Once on the General tab select “From Device” for the source for restore, then navigate to the .bak file you’re restoring to.
  5. Ensure the Destination for restore is set to the correct database.
  6. Select the Options tab.
  7. Check “Overwrite the existing database (WITH REPLACE)
  8. Click OK
If, while performing the above steps in either versions of SQL, you receive an error stating that the database is unable to be restored because it is in use please follow the steps below.

  1. Open IIS
  2. Expand the server name.
  3. Click on Application Pools.
  4. Right click on the application pool for the domain and click Stop.
  5. Click on Sites.
  6. Select the site name and click Stop under Manage Web Site.
  7. Repeat the steps above for the version of SQL Server.
  8. Once the restore is complete Start both the Site and Application Pool of your site.