https://community.hpe.com/t5/server-management-systems/sql-log-file-grows-out-of-control/m-p/3476850#M9599 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). Fri, 04 Feb 2005 09:24:06 GMT Etienne Beureux 2005-02-04T09:24:06Z https://community.hpe.com/t5/server-management-systems/sql-log-file-grows-out-of-control/m-p/3476849#M9598 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.<BR /><BR />Will someone please help this newbie get a grip on this? Wed, 02 Feb 2005 10:48:49 GMT https://community.hpe.com/t5/server-management-systems/sql-log-file-grows-out-of-control/m-p/3476849#M9598 Carl Passman 2005-02-02T10:48:49Z https://community.hpe.com/t5/server-management-systems/sql-log-file-grows-out-of-control/m-p/3476850#M9599 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). Fri, 04 Feb 2005 09:24:06 GMT https://community.hpe.com/t5/server-management-systems/sql-log-file-grows-out-of-control/m-p/3476850#M9599 Etienne Beureux 2005-02-04T09:24:06Z https://community.hpe.com/t5/server-management-systems/sql-log-file-grows-out-of-control/m-p/3476851#M9600 That's the same thing our SQL DBA said...<BR />I thought I had something configured wrong in SIM.<BR /><BR />Thanks for the great advice! Fri, 04 Feb 2005 10:39:39 GMT https://community.hpe.com/t5/server-management-systems/sql-log-file-grows-out-of-control/m-p/3476851#M9600 Carl Passman 2005-02-04T10:39:39Z