Q
Problem solve Get help with specific problems with your technologies, process and projects.

Transaction log space verses data space

Transaction log backups can be issued while using full recovey backups.

Why is the transaction log space sometimes larger than the data space? Also, I have a maintenance plan setup which is supposed to delete .bak and .trn files older than the current dates, but it doesn't seem to be acting accordingly. How can I fix this?
The transaction log usually gets larger than the data file when you have large transactions that are run, and run often, prior to a transaction log backup occurring. Check the transactions that are running to see if there is a way to make them smaller so you do not generate such a large amount of data. Also, make sure that you are running transaction log backups on a set schedule or change your recovery model to "Simple" if you do not need transaction log backups.

As far as the maintenance jobs not cleaning up, you may want to just recreate the maintenance plans, delete the...

older files that did not get deleted and see if that takes care of the problem.

This was last published in August 2006

Dig Deeper on SQL Server Backup and Recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close