Task 2.4: New Server with no backups

Whenever possible restore data from backups. If your backups are corrupt or non-existent, the following tasks can help you restore your data to some extent.

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

If you are simply replacing a file server, see task 5.8 in the “Installing TraCS” section.

Please contact badgertracs@dot.wi.gov if you 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 these tasks for recreating a specific database from Scratch.