Link to home
Start Free TrialLog in
Avatar of SigmundFraud
SigmundFraud

asked on

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?

Thanks
Avatar of chapmandew
chapmandew
Flag of United States of America image

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...
Avatar of SigmundFraud
SigmundFraud

ASKER

Indeed you are right but i would like multiple safeguards as recently the backups failed and the notifications were not sent out.
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial