Suspect database found in TVC

From wiki.comcert.com
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