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.
NOTE: Refer to the Microsoft website for recovering databases. https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-database-backup-using-ssms?view=sql-server-ver16
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.
If the server name has changed, then the TraCS Database Connections in the TraCS Configuration Manager will need to be updated.
Starting with a brand new SQL Server install, your screen should look like this:
Right click on Databases and select Restore Databases
Under the General page
Select Device
Select the …
Make sure the backup media type is set to file
Click add
It should automatically navigate to the default backup location.
Locate and select your backup file. The file name should match the database you are looking for.
click OK. You should see the file mentioned in the backup media after pressing OK
Press OK again
Click the Options page and select “overwrite the exsisting database (WITH REPLACE)” and click OK
Click OK and it should import.
Repeat these steps for each database.
Add Comment