We keep an offsite copy of a live DB. We currently refresh thus;
1) Back up the ENTIRE live DB,
2) Copy .bak file(group) to Offsite server;
3) Restore (With replace)
However, only 2% approx of the data has changed, so we are throwing a lot of un-needed data across narrow bandwidth. Also space on that offsite server is very restricted.
So I'd like to change step 1 to;
1) Backup ONLY those tables updated on Server1.DB1 since Server1.DB2 was created;
What is the best workflow to do this in SS2K, bearing in mind FK's, and the live DB is already a log-shipping primary being backed up every 15 minutes?