General discussion
January 22, 2003 at 11:44 PM
fabio dpi net

SQL Transaction Log takes all the space

by fabio dpi net . Updated 23 years, 8 months ago

Hello,

I’ve a SBS2000 and I have a problem with SQL Server 2000: One database log did grow up to fullfill the hard drive. Now I did limit it, but it’s 18gb while it should be a few mb. What sould I do to bring it back to the real size? Should I do an offline defragmentation? How?

Many Thanks

Fabio

This discussion is locked

All Comments