tags:

views:

18

answers:

0

Hi...

I have a table (Cycle)...

Then I create a trigger

**

alter trigger AnyName on Cycles
for insert,update,delete
AS
BACKUP DATABASE medrepcrm TO  DISK = N'C:\medrepcrm.bak' WITH NOFORMAT, INIT,  NAME = N'pcrm-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

**

but,when I insert,update or delete in cycle table that lead to error...

**

Msg 3021, Level 16, State 0, Procedure AnyName, Line 8 Cannot perform a backup or restore operation within a transaction. Msg 3013, Level 16, State 1, Procedure AnyName, Line 8 BACKUP DATABASE is terminating abnormally. The statement has been terminated.

**

what can i do ?