Versions Compared

Version Old Version 6 New Version Current
Changes made by

Julian Pazynski

Julian Pazynski

Saved on

Key

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

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

...

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

We need to run the WIPack now to fully configure all databases and run a DBSync too.

  1. 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=

  2. Open TraCS on Master Computer.

    1. You should get prompted for update to run like normal.

...