Is it possible to trigger a database trigger during recovery in SQL 2005 or 2008

Question

I have some book storage tasks (reset high water marks, clear some phased data) that need to be performed after each restore of the QA database. I know that I can create triggers for databases in SQL, but it seems I cannot find a way to do this when restoring the database.

Since I’m working on a team of people sharing a database, I don’t always know when recovery occurs. Is there a way to automate this either with a trigger or with some other database magic so that the cleanup routine is always called?

Answer 1

There is no DDL trigger for RESTORE, however an Event Notification for an eventAUDIT_BACKUP_RESTORE_EVENT that takes you to where you want.

Answer 2

http://www.eggheadcafe.com/conversation.aspx?messageid=33217985&threadid=33217985 http://msdn.microsoft.com/en-us/library/bb522542.aspx http://msdn.microsoft.com/en- us / library / ms189871.aspx

Does not seem possible. What about the recovery script, including the maintenance procedures at the end of the script?