Friday, February 24, 2012

file ldf too BIG

Hi all!
I would like to reduce the size of MyDataBase_Log.ldf
I use Sql Server 2000.
If it was possible which procedure i have to follow?
Thanks
FractalBlueDo you have any maintenence going on?

You need to Dump the log and truncate at checkpoint

Then lookup DBCC SHRINKFILE

in BOL

No comments:

Post a Comment