mega_stream

This morning I've become a dba


Got an error message on SQL saying the transaction log is full, checking the log drive and it sure is

Question is, how do I reduce it?, ran truncate log file, says it has but the file is the same size with no free space still.

Can anyone offer any help? Got an MCSE sitting next to me, who has passed his SQL exam, he hasn't got a clue. Another example of the worth of an MSCE [img]images/smilies/mad.gif[/img]

Cheers

John

[Edited by mega_stream - 11/5/2002 8:35:30 AM]

IanW

What method did you use to try to truncate the transaction logs?

GaryK

mega

A log backup normally tries to shrink the transaction log, have you tried this (after doing a full db backup of course!)

Gary

dharbige

Try runnnibg a query against each of your databases that just has the word "checkpoint" in it. Then truncate the transaction log again.

Jerome

Right click on the database in question and click on properties.

Click on the Transaction Log tab.

In the Maximum file size bit, click on the Restrict File Growth (MB) button and set the file size to be, say, 2MB.

mega_stream

Thanks, actually did it when I truncated the transaction log, I assumed the free space would go up after I did this, obviously don't

All sorted now