Server Management - Systems Insight Manager
1833782 Members
2641 Online
110063 Solutions
New Discussion

Re: SQL Logs Growing Quickly

 
RHagen_1
Advisor

SQL Logs Growing Quickly

In our SIM V 4.2 sp2, We're getting ready to upgrade to ver 5 SIM but our SQL logs are growing to over 2 gb in about 3 days.

I followed some suggestions on setting the remote SQL DB data recovery to 'simple' and set to autoshrink. I also perform daily backups of this SQL log file on the SIM server with Netbackup but it still does not shrink this file. So I stopped backing up this SQL log file on the SIM server. I also set Bi-weekly data collection to 'over write'.. I stopped the PMP service to slow down the log file growth but it's still growing...

Any Help?
2 REPLIES 2
RHagen_1
Advisor

Re: SQL Logs Growing Quickly

Sorry I duplicated this on my earlier thread... I will close this one out...
RHagen_1
Advisor

Re: SQL Logs Growing Quickly

duplicate