error 3021 - backup with trigger

• Aviad C.

  SSChasing Mays

  Points: 602

  More actions

  August 2, 2010 at 11:59 am

  #221990

  hi, i make a trigger that backup database when created, the problam that I had this error 3021 -

  " msg 3021, cannot perform a backup or restore operation within a transaction"

  myby someone can help me ?

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  August 2, 2010 at 12:56 pm

  #1201193

  The database backup cannot be taken amidst a transaction, like in trigger.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga