How to control SQL Server transaction log growing to a maximum size

10 pts.
Tags:
SQL Server
SQL Server transaction logs
Transaction log in SQL Server getting completely growed to maximum size frequently even when it is being backed-up and shrinked.. Please provide early and feasible solution.. What is the possible cause for the growth of transaction log to that extent.. and how to avoid it...

Answer Wiki

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

It’s probably being caused by maintenance plans rebuilding indexes and updating statistics.

There isn’t any way to stop it from happening. You need to plan for this. You may need to increase the size of the log drive.

Discuss This Question: 2  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,010 pointsBadges:
    report
  • Denny Cherry
    I pulled the other answers out of the answer as they don't appear to apply. Have you been able to resolve your problem?
    66,010 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