I have a task to do.
I have to create a table which holds information about any database bacp-up done on server (dbid from system_databases table, date of backup, kind of backup, file location).
Problem is that I haven't found event which could be used in a trigger.
How can I make a row inserted into this table with all the required information any time back-up is performed? (doesn't matter if back-up is scheduled or performed manually).
Can I use some of system tables, procedures?