Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Database log file

 
SOLVED
Go to solution
Highlighted
Occasional Advisor

SQL Database log file

Hi there,

Environment;

Windows 2003, HP SIM v4.1 and about monitoring about 450 managed systems.

Query;

The log files have been steadily increasing and stand at 97gb on a 143gb disk. At the moment the log file is configured to unrestricted growth but it's behaviour is contrary to another HP SIm box.

Does anyone know of any reason why this would be happening? Can I delete this log file, and then restrict the size of the new one? any advice would be appreciated.

Thank you

Joe
7 REPLIES 7
Highlighted
Trusted Contributor

Re: SQL Database log file

On the SQL Server, Change the database type to "Simple" and set it to "auto-shrink". It'll stay around a few MB then.
Highlighted
Frequent Advisor

Re: SQL Database log file

Hello Joe,

if you are using MS SQL server this should help


created a DB Maintenance plan for the insight db.

added to the transactionlog backup step a second step with this SQL states
------
use Insight_v1_0
DBCC SHRINKfile(Insight_v1_0_log, 0)
------

let this run every 30 minutes an kill all transactionlogbackup that are older than 2 hrs, then it should not grow beyond 200 MB

you will surely have to adjust the statement to oyur db names and filegroups names, but after that it will work.

hope this helps
Highlighted
Occasional Advisor

Re: SQL Database log file

Hi James,

Thanks for your reply. Just to clarify, What effect if any will this have? Will it reduce/ Shrink the already huge transactio logs or do I have to delete the existing transaction log file.

Also will this setting (auto shrink) not have an adverse effect on database performance.

Please forgive me as my SQL knowlegde is limited.

Thanks

Joe
Highlighted
Occasional Advisor

Re: SQL Database log file

Hi Claas,

Thanks for your reply.

Please forgive me as my SQL knowlegde is limited.

I am not totally clear on your suggestion.

The Insight manager database is not currently being backed up via SQL but by an enterprise solution.

I have read that it would be a good idea to create a backup maintenance plan for database and transaction logs, change the recovery mode to simple as suggested by James and this should work.

What do you think


Cheers
Highlighted
Trusted Contributor
Solution

Re: SQL Database log file

Joe,

At the size of the log files you have right now, it'd be very difficult to do any backups. You definately want to get it shrunk down, and then you can setup a backup plan if you desire.

Backing up the logs aren't that important unless you require the ability to do a restore to the exact moment of a loss. Generally I don't consider the SIM database logs that important, as they will recreate themselves based on newly collected data.
Highlighted
Occasional Advisor

Re: SQL Database log file

Thank for your help James
Highlighted
Valued Contributor

Re: SQL Database log file

Hi James / Joe

I am facing same problem my sql data mdf log files are increasing facing problem while starting the SM

Please help me how to delete these files

I dont have SQL so much Knowledge.

size is incresing please help needed critical

REgards
VAsu