Leave the SCCM database out of your backup scheme.  
That handles the backups, and possible restores, itself.  
What you do want to do is find the backups, they are in...

This sounds like a good example of the things that should NOT be done in a trigger.

The latency between the data centers should determine if you choose synchronous or asynchronous.  In synchronous mode, the commits occur at the secondary first, and then are committed at the...

Some people do not get that you didn't really name your table "A", and your columns "Col1, Col2.."   Most of us understand that this was only a basic example. 

Without a sample of the exact table structure, and some sample data, the answer is any number of ways.

Try using a trigger, although you probably do not want to send an email directly from a trigger. 
Create an insert trigger, when it fires, capture the relevant information for...