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

...

Info
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.

...

Make sure to give your agencies TraCS SQL user owner rights to the database.
Run the Custom distribution file. (This adds state access levels.)
1. If you set up Task 6.1: Download Tables Upon Login
2. On your server you should be able to located the distribution and run it C:\ProgramData\TraCS\Download\Tables\*LocationID*\AgencySupportTable.dist.exml
3. Remove the Distribution Log. xml file
  1. Navigate to C:\ProgramData\TraCS\Settings
  2. Delete DistributionLog.xml
4. In the configuration manager, select the update tab.
  1. Click the run distribution button.
  2. Navigate to the C:\ProgramData\TraCS\Download\Tables\*LocationID*\ folder
  3. Select AgencySupportTable.dist.exml
Run the Distribution file found in your mobile distribution.
1. Remove the Distribution Log. xml file
  1. Navigate to C:\ProgramData\TraCS\Settings
  2. Delete DistributionLog.xml
2. In the configuration manager, select the update tab.
  1. Place the distribution file onto C:\ProgramData\TraCS\Distribution
  2. Edit the Distribution Deleting all except the following.
3. Save
4. Click the run distribution button.
You could also manually create a distribution file from a mobile unit. More directions to come

...

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.

Content Comparison