OnePoint and SMAuditDB are in Suspect mode. (NETIQKB17294)

fact
Security Manager 4.x

symptom
OnePoint and SMAuditDB are in Suspect mode.

fix

Please verify that the disk containing data files for these databases have enough free disk space. Before running this stored procedure make sure disk is not running out of space. Here a stored procedure you can run using SQL Query Analyzer. You can get more information from SQL Books online by doing a search for 'resetting the suspect status'.

USE master
GO
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO
sp_resetstatus onepoint
GO

After recording the results run the stored procedure below:

sp_configure 'allow updates', 0
GO
RECONFIGURE WITH OVERRIDE
GO

Formerly known as NETIQKB17294