Versions Compared

Version Old Version 1 New Version Current
Changes made by

Geraldine Polster

Julian Pazynski

Saved on

Key

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

Task 2.4.3(b): Recover Support 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.  

...

  1. In SQL Server Management Studio (SSMS)

    1. Create Paste the query below to create the tracs_Support support database. You should use the copy button in the code snippet below.

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

...

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

...

Reset to Zero Pack

  1. Remove the Distribution Support. xml file

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

    2. Delete DistributionSupport.xml

  2. Reset the Registry file

    1. Navigate to C:\Program Files (x86)\TraCS

    2. Edit RegistryKeyName.ini

    3. Delete everything after TraCSPack=

...