Run tlog backups without logging into the error log?

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  June 9, 2008 at 7:20 am

  #191767

  Hey all,

  I want to omit transaction log backup logging into the error log or msdb.dbo.backupset. Is this possible?

  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736458

  More actions

  June 9, 2008 at 7:54 am

  #826106

  I think there's a way to do this with a trace flag or registry setting.

  http://www.mssqltips.com/tip.asp?tip=1457

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  June 9, 2008 at 8:00 am

  #826112

  Ah! I remember seeing that before ... forgot all about it.

  Thanks!