We have below options to deal with the over growing transaction log file:
Freeing disk space so that the log can automatically grow.
• Backing up the log. • Adding a log file on a separate disk drive.
• Increasing the size of a log file
• killing a long-running transaction
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment