haiao2000 (4/11/2013)
Have you thought of an alternate solution like SQL replication, infacts merge replication is good way to go. create publisher/subscriber, then schedule it to synchonize once a week?
Why? This affords the opportunity to test the backups to ensure that a restore is possible. Remember: backups are worthless, restores are priceless.