empty log file

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

nagdimunovd SSC-Addicted Points: 496 More actions · Answer 1

BACKUP LOG [dbname] WITH TRUNCATE_ONLY

I would reccomend to actually back up the file before you truncate it.

quote:
Hi guys!
Can you help me to clean up or reduce the size of log file in MS SQL 2000.
Thank you in advance
Alex
alex@info-x-inc.com