Task 2.4.4(b): Recover Data 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. |
...
In SQL Server Management Studio (SSMS)
Create Paste the query below to create the tracs_Data data database. You should use the copy button in the code snippet below.
| Code Block | ||
|---|---|---|
| ||
USE master GO CREATE DATABASE tracs_Datadata GO use tracs_Datadata 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.
...
Run the BTDBData distribution file. (This adds state access levels.)
Remove the Distribution Data. xml file
Navigate to C:\ProgramData\TraCS\Settings
Delete DistributionData.xml
In the configuration manager, select the update tab.
Click the run distribution button.
Navigate to the C:\ProgramData\TraCS\Distribution\Templates folder
Select BTDBData.dist.exml
Perform a database sync.
...
In the configuration manager, select the utilities tab.
...
Click the Database Sync button.
...