Suspect database found in TVC

From wiki.comcert.com
Revision as of 06:53, 2 October 2019 by Bert (talk | contribs) (Created page with " This procedure is for MS-SQL and therefore only valid on TruView Central version 10 and earlier.   Run the following SQL query (replace the name of the DB as needed)...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

This procedure is for MS-SQL and therefore only valid on TruView Central version 10 and earlier.

 

Run the following SQL query (replace the name of the DB as needed)


EXEC sp_resetstatus "VUpTimeDC";
ALTER DATABASE VUpTimeDC SET EMERGENCY
DBCC checkdb("VUpTimeDC")
ALTER DATABASE VUpTimeDC SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ("VUpTimeDC", REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE VUpTimeDC SET MULTI_USER

Retrieved from "https://wiki.comcert.com/index.php?title=Suspect_database_found_in_TVC&oldid=4778"