Question

alert log file to monitor disk space

BizTalk, Disk quota management, SQL Server

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?

You will want to schedule transaction log backups to occur on a regular schedule. This will keep the transaction logs from growing to large.

If you don't need to be able to do a point in time restore then you can change the database recovery option from FULL to SIMPLE.