Versions Compared

Version Old Version 3 New Version 4
Changes made by

Geraldine Polster

Geraldine Polster

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
USE master
GO
CREATE DATABASE tracs_log
GO
use tracs_log
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) 

  1. Create the needed tables in the tracs_log database using the “log” SQL script. The script will be in c:\programdata\tracs\Baseline Files\Scripts\ Baseline Log Total SQLServer.sql

Info

Note: a common error is to run the script against the default database, which is typically not the tracs_data database.  Either change the default database in SSMS to tracs_data or add the following lines to the script before running it—

Code Block
USE [tracs_log]
Go

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

  2. Run the BTDBLog 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 BTDBLog.dist.exml