Event Notifications - an interesting example - Handle backup/restore audit events
Posted by: SQL Server 2005 Distilled,
on 04 Dec 2005 |
View original | Bookmarked: 0 time(s)
You may know that Service Broker gets disabled when a database is restored or when a database is attached. What if you need to enable it whenever a database is restored This is just one example, but what if you want to perform some similar post-restore actions
Here is one of the solutions to this problem. It makes use of the new Event Notifications feature introduced in SQL Server 2005. The server event AUDIT_BACKUP_RESTORE_EVENT is fired whenever a database backup operation is performed or when...