January 21, 2014 at 7:34 am
Hi,
I want to create a trigger that fires (logs data into a table named backups inside a database named audit every time someone makes a backup to one of the user databases.
I would like to do the same for restore (log the restore into a table named restore inside my user database named audit).
Where can I put this triggers? Inside Master database? In which tables?
Thank you
January 23, 2014 at 1:31 pm
You don't really have to bother. This is already in the msdb database. Have a look at the backupset and restorehistory tables there.
January 23, 2014 at 2:15 pm
AND the SQL Server logs unless you've instantiated the trace flag that turns off reporting of successful backups.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply