Backup log

• Susan S

  SSCommitted

  Points: 1771

  More actions

  October 31, 2007 at 7:53 pm

  #122184

  I am running this sql query.

  BACKUP LOG [NAV TO DISK = N'\\dcu\MSNAVCLDB\NAV\NAV_Log_Trun.trn' WITH TRUNCATE_ONLY

  when I check it in the dcu\MSNAVCLDB\NAV folder I couldn't find the file.

  what do I do wrong here?

  Thanks,

  Susan

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736059

  More actions

  October 31, 2007 at 8:52 pm

  #747306

  When you use TRUNCATE_ONLY, no log backup is performed. The log file is just truncated.

  You should not be using TRUNCATE_ONLY in general. Just run backup log with the disk path.

  http://msdn2.microsoft.com/en-us/library/ms186865.aspx

• Susan S

  SSCommitted

  Points: 1771

  More actions

  October 31, 2007 at 9:53 pm

  #747311

  Thanks Steve