Task 2.4.4(b): Recover Data Database, SQL Server Alternative

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

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

1. In SQL Server Management Studio (SSMS)

   1. Paste the query below to create the tracs_data database.

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

3. Make sure to give your agencies TraCS SQL user owner rights to the database.

4. Run the BTDBData distribution file. (This adds state access levels.)

   1. Remove the Distribution Data. xml file

      1. Navigate to C:\ProgramData\TraCS\Settings

      2. Delete DistributionData.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 BTDBData.dist.exml

5. Perform a database sync.

   1. In the configuration manager, select the utilities tab.

   2. Click the Database Sync button.

   3. In SQL Server Management Studio (SSMS), create the tables to store the form data in the tracs_data database by running the “Delta” SQL script. The script will be in the TraCS network folder under the DBData\SQLScripts folder.  The name of the script takes the form of <Timestamp>Delta.sql.  If there is more than one “Delta” script present, run the one with the most current timestamp.

6. Recover forms

   1. Recover forms from standard mobile clients.  (Typically the last 90 days of forms are available.)

      1. Have officers do a resend of any forms available on their mobile computer. 

      2. End-shift the forms into the TraCS office database.

      3. Use the Update Transmission Status button to mark forms as transmitted for any forms that you believe have already been transmitted.

   2. Recover forms from web services clients.  (Typically the last 90 days of forms are available.)

      1. Copy document files from C:\ProgramData\TraCS\DocumentBackup to C:\ProgramData\TraCS\Document on the web services client.

      2. The next time the client is started, it will automatically begin checking in the forms, populating the database.

      3. Use the Update Transmission Status button to mark forms as transmitted for any forms that you believe have already been transmitted.

7. Order new traffic citation numbers.  Order Citation Numbers from EARS