empty log file

• alexkokit

  Valued Member

  Points: 66

  More actions

  May 15, 2002 at 12:22 pm

  #58167

  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

• nagdimunovd

  SSC-Addicted

  Points: 496

  More actions

  May 15, 2002 at 12:41 pm

  #429204

  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

  ---