Troubleshooting database log file error messages
Development expert Greg Low troubleshoots a full database log file error message.
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
Step 2 of 2:
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.
I am in the process of migrating my SQL server 2000 databases (SP3) from Win NT to a new server with Windows 2000. The system consists of a main database "MAINDATA" (85 MB) and a secondary database "SECONDARY" (5MB). I use DTS to update table in the "SECONDARY" database. This process has been running smoothly for many years now on the old server. After migration, when I run the DTS on the new server, I receive an error message indicating that the log file for "SECONDARY" database is full. This is very strange because I have plenty of disk space on my new server. Also, the settings for the log files allow automatic file growth with adequate restrictions. I tried everything that normally solves the problem in such cases including log truncation and database shrinking, etc. with no success. The same settings were working on my old server. Would you please tell me how to troubleshoot this problem?
In this case I'd be tempted to take SQL Server's error message at face value. Try manually setting the database log file to a larger value, instead of relying on the auto-grow behavior.
This was first published in January 2006
Dig Deeper
PRO+
Content
Find more PRO+ content and other member only offers, here.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our SQL Server experts
View all SQL Server questions and answers
0 comments
Oldest Newest