HPE Community
Server Management - Systems Insight Manager
1836623 Members
2061 Online
110102 Solutions
New Discussion

SQL log file grows out of control

 
SOLVED
Go to solution
Carl Passman
Occasional Contributor

‎02-02-2005 02:48 AM

‎02-02-2005 02:48 AM

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?
0 Kudos
Reply
2 REPLIES 2
Etienne Beureux
Advisor

‎02-04-2005 01:24 AM

‎02-04-2005 01:24 AM

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).
Reply
Carl Passman
Occasional Contributor

‎02-04-2005 02:39 AM

‎02-04-2005 02:39 AM

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!
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.