Backup Coupled Databases Consistently
Our production system consists of two SQL 2005 databases A and B on different servers. Server A is running SQL Backup 4.
Server B is running SQL Backup 5.
Server A has a set of Tables which are replicated to B with Transactional Replication.
Server B has a set of Tables, Server A Has Views of the same name which look at these tables. All other tables on B are subscriptions to A's Publication.
What I want to ensure is that the Full backup of these two databases is taken at precisely the same point in time. This will make restoring the db to another environment easier than doing the restores and then doing a WITH STOPAT Log Restore and trying to match them up based on DateTime.
Anyone know a good solution to this ?
(Would prefer not to put the dbs in SINGLE USER MODE)