ApexSQL Log Tools

Urg! One word to describe an interesting surprise I ran into today. On the Production server the tool created an extended stored procedure that started logging every login that takes place on server in the MSDB. Which I was unaware of and got caught by surprised, so my production server HDD went from 30%+ free less then 10%+. I admit it happened slowly I didn’t notice it until my alert came in for less then 10% free.

I don’t remeber receiving any alerts when I was running the tool that it will be logging information into MSDB; so it was surprised. So for now I have turned off their logging Extended Stored Procedure and truncated the table in question. I understand from reading a bit on it it gets used to report who executed what when reviewing T-Log; but I wish I knew so I can truncate and backup it up.

For now I am truncate and shrinking the file until I can implement or come up with a plan to save this information.

Ref: http://www.apexsql.com/knowledgebase/2007/08/troubleshooting-very-large.htm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.