Task 2.3: Restore SQL Databases From Backups

Whenever possible restore data from backups.  If your backups are corrupt or non-existent, then you should see the note below to see if Microsoft’s documentation can help you recover the databases.

Please contact badgertracs@dot.wi.gov if you and your IT are unsure of which data recovery options are appropriate to your agency’s situation.  We’re here to help.

If you cannot recover the database, refer to Task 2.4 on how to start a new server with no backups.

How to Restore Databases Using Your Backups to a New SQL Server.

1. Starting with a brand new SQL Server install, your screen should look like this:

Open

2. Right click on Databases and select Restore Databases

   Open

   

3. Under the General page

   1. Select Device

   2. Select the …

   3. Make sure the backup media type is set to file

   4. Click add

      Open

      

4. It should automatically navigate to the default backup location.

5. Locate and select your backup file. The file name should match the database you are looking for.

   1. click OK. You should see the file mentioned in the backup media after pressing OK

   2. Press OK again

6. Click the Options page and select “overwrite the exsisting database (WITH REPLACE)” and click OK

   Open

   

7. Click OK and it should import.

8. Repeat these steps for each database.