topic Re: SQL Logfile Space in Server Management - Systems Insight Manager

SQL Logfile Space

Derek_31 — Mon, 16 Aug 2004 22:20:13 GMT

I've had SIM 4.1 running on a server for a while now. The other day SQL is now complaning that the SQL log file for Insight ran out of space. I went into SQL and did a shrink and a full backup. It shows a lot of free space on the database tab, but Insight can't connect up without a ton of log file full messages on the SQL server.

What can I do?

Re: SQL Logfile Space

So Def — Tue, 17 Aug 2004 04:07:30 GMT

I had the same problem. My sql database was 10 Gig. Half of it was the log file.
You can control the SQL filesize and still have SIM running smoothly by:

Ensure the database model is set to simple.
Enable the autoshrink option. Automatically grow option for both the database and log file should be enabled as well as the unrestricted file growth.

Create an automatic event to delete events older then e.g. 2 months.
You can do this by setting up a custom event list view. I delete them manually from this view as I like to be in control what is deleted.

By shrinking the database the SQL was reduced to 5 GIg. By controlling the amount of events my database is only 500 MB.
As you can see if you don't keep a lit on it the sim database will grow.

Re: SQL Logfile Space

Derek_31 — Wed, 18 Aug 2004 10:05:20 GMT

Thanks! I changed it to simple and played around with the shink command, and got things working again.