Home Forums SQL Server 2005 Backups How to write trigger on server level to take backups of databases before it is deleted. RE: How to write trigger on server level to take backups of databases before it is deleted.

  • November 5, 2008 at 1:08 am

    #894080

    Look for use of 'INSTEAD OF Triggers'. As triggers are of two types after and instead of. in your case 'instead of trigger' may work.

    DBDigger Microsoft Data Platform Consultancy.