You've stored the backup file in a safe place, but what kind of info do you store with it?
- database type (SQL Server)
- compatibility level (SQL Server 2008)
- application name
- application owner
- application version
closed as primarily opinion-based by Mark Storey-Smith, Paul White♦, Max Vernon, RolandoMySQLDBA, Shawn Melton Dec 11 '13 at 4:53
Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise. If this question can be reworded to fit the rules in the help center, please edit the question.
I have designed a database archiving process - which is a semi automated process.
Below are my thoughts :
Note that you have to develop your custom solution based on your organizational needs
The key here is
Remember that triggers (whatsoever) cannot be used for backups. For backups, you have to tailor your own custom solution, but the idea remains the same.