\Task 2.4.5(b): Recover Custom Database, SQL Server Alternative

Note: It is recommended that you contact badgertracs@wi.dot.gov to help you assess your agency’s situation. There may be less drastic options available depending on the extent of the damage.

Purpose: Recreate the TraCS Custom database when it is destroyed beyond repair and no backups exist.

Requirements: TraCS Installation files, access to field unit with TraCS mobile installed.

In SQL Server Management Studio (SSMS)
1. Paste the query below to create the tracs_custom database. You should use the copy button in the code snippet below.

USE master
GO
CREATE DATABASE tracs_custom
GO
use tracs_custom
GO
DECLARE @sql1 VARCHAR(1000)
SELECT @sql1='ALTER DATABASE '+quotename(db_name())+' SET ALLOW_SNAPSHOT_ISOLATION ON
			 ALTER DATABASE '+quotename(db_name())+' SET SINGLE_USER WITH ROLLBACK IMMEDIATE
			 ALTER DATABASE '+quotename(db_name())+' SET read_committed_snapshot ON
			 ALTER DATABASE '+quotename(db_name())+' SET MULTI_USER'
exec(@sql1)

We need to run the WIPack now to fully configure all databases and run a DBSync too.

From the Master computer
1. Reset to Zero Pack
2. Reset the Registry file
  1. Navigate to C:\Program Files (x86)\TraCS
  2. Edit RegistryKeyName.ini
  3. Delete everything after TraCSPack=
Open TraCS on Master Computer.
1. You should get prompted for update to run like normal.