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.

  • You can create DDL trigger as

    CREATE TRIGGER ddlTrigger

    ON ALL SERVER

    FOR DDL_LOGIN_EVENTS

    AS

    .....

    ..

    .

    You can use EVENTDATA() function that returns info such as event time, SPID, and type of event firing the trigger in form of XML data.

    DBDigger Microsoft Data Platform Consultancy.