How do I maintain my OnePoint database?
Security Manager 5.X
Operations Manager 3.X
Security Manager 3.X
Security Manager 4.X
Most of the time the database will not need much administration due to the maintenance jobs that are configured at installation. However, when troubleshooting database problems make sure that the "autogrow" option is not selected on the OnePoint database properties page. Refer to the following article for more information:
NETIQKB1983 Should I enable the OnePoint database for automatic file growth
By far the most common database problems stem from a database with not enough free space. This will cause an assortment of issues. Refer to the following article for more information:
NETIQKB855 What does the error 'Could not allocate space for object 'Event' in database 'OnePoint' because the 'PRIMARY' filegroup is full' mean?
NETIQKB2142 How can I manage the database reindexing jobs?
Planning an effective database grooming schedule relative to the amount of information that is being written to the database is the best way around this problem. Refer to the 'Most Common Events' report to get a listing of the events that are taking the most hard disk space on your SQL Server.