Working...

Suspect Dbase (Database)

Fixing Suspect Dbase

With power outages / forced power-off, a rare condition can occur where 'FastBar' dbase shows as (Suspect).  The following script will most times clear this.  From SSMS, Windows login, Execute Query:

 

EXEC sp_resetstatus [FastBar];

ALTER DATABASE [FastBar] SET EMERGENCY

DBCC checkdb([FastBar])

ALTER DATABASE [FastBar] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ([FastBar], REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE [FastBar] SET MULTI_USER