I have a sql server which has some Biztalk databases which can grow like wildfire on a daily basis, where log files can grow to 20 gig in an hour. Is there a way to set an alert based upon a log file size growing to big that I can fire an sp on to shrink when needed. Or any other better approach?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!