• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 656
  • Last Modified:

SP to monitor log file growth and send alert

We are running a database on SQL Server 2000 and I would like to monitor the growth of the log file as it recently maxed and crashed the live system.

For instance if I allocate 10GB of space to the log file i would like a stored procedure to alert me if it reaches a certain threshold; e.g 80%.

Can someone assist me with this?

  • 2
1 Solution
Instead, why don't you just setup log backups as part of your maintenance routine?  If you did, you'd likely not have to worry about your log getting too large...
SigmundFraudAuthor Commented:
Indeed you are right but i would like multiple safeguards as recently the backups failed and the notifications were not sent out.
Here's an article I wrote awhile back that should do it for you:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now