Server Management - Systems Insight Manager
1833871 Members
1808 Online
110063 Solutions
New Discussion

SQL log file grows out of control

 
SOLVED
Go to solution
Carl Passman
Occasional Contributor

SQL log file grows out of control

The SQL db on SIM 4.1 CMS is only 100MB but the log file has grown to over 12GB! Bi-Weekly Data Collection scheduled task is set to overwrite. The other scheduled tasks are Initial Data Collection, Daily Device Identification, and Status Polling.

Will someone please help this newbie get a grip on this?
2 REPLIES 2
Etienne Beureux
Advisor
Solution

Re: SQL log file grows out of control

Change the recovery model of the HP SIM SQL database to "simple", or schedule regular transaction log backups of this database (since the transaction log is truncated after a backup).
Carl Passman
Occasional Contributor

Re: SQL log file grows out of control

That's the same thing our SQL DBA said...
I thought I had something configured wrong in SIM.

Thanks for the great advice!