alert log file to monitor disk space

95 pts.
Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,185 pointsBadges:
    report
  • Xavierk08
    As everyone says that changing the recovery model from Full to Simple with resolve....but it is myth...let us assume that it is in simple recovery model still the log file will increase as there maybe a bulk insert/bcp or a begin/commit stuff......We should know how much size it increased to take precautionary steps....for that, we need to have a script to capture the size of the LDF.........i have created a script long back (3 years ago) and i will place it soon on my blog is ready..cya soon.. Xavier K.
    20 pointsBadges:
    report
  • Xavierk08
    TCSTL, Change the recovery model to SIMPLE and then make sure you keep an alert on the log file size growth of that database.......before that make sure u have a DBMail configured and a Operator configured for the same to receive alerts.....upon the checking the behavior n growth of the ldf you can create trigger a job to shrink the log file... Hope this will help in taking precautionary steps.
    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following