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. |
...
In SQL Server Management Studio (SSMS)
Paste the query below to create the tracs_support database. You should use the copy button in the code snippet below.
| Code Block | ||
|---|---|---|
| ||
USE master GO CREATE DATABASE tracs_support GO use tracs_support 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) |
...