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
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
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...
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.