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]

 

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

 

mega

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

Gary

 

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

 

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.

 

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