Task 2.4.2(b): Recover Users 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 Users 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_users database.

USE master
GO
CREATE DATABASE tracs_users
GO
use tracs_users
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)

Run a batch file to create the tables for tracs_users database: C:\Program Files (x86)\TraCS\Baseline Files\Distribution\Total\TraCS Baseline Total Users.bat
Run the BTDBUsers distribution file. (This adds state access levels.)
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. Click the run distribution button.
  2. Navigate to the C:\ProgramData\TraCS\Distribution\Templates folder
  3. Select BTDBUsers.dist.exml
Referring to your as-built document, recreate the TraCS user groups. See Task 3.18: User Groups for details. You will need to use account #00001 with a password of tracs.
Import user files (on your web clients you have copies of the users stored after each successful login) You can grab a copy of these files and import them into your new database.
1. On your web clients grab all the files in C:\ProgramData\TraCS\Users\
2. Place them on the server.
3. In the Configuration Manager go to the User editor
  1. Click the Import button
  2. Click Import User Files
4. Choose all the files and click Open.
Recreate any agency level defaults. (See Task 1.7.1: Configure DEFAULTS Accounts and Task 3.15 Set Agency Level Field Defaults .