Log shipping Published DB

Last Post 25 Jan 2006 09:49 PM by Paul Ross. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Paul Ross
New Member
New Member

25 Jan 2006 09:49 PM
I have a database that contains many merge replication publications (approx 100). The database is being copied to a disaster recovery site via log shipping (custom written). BOL seems to indicate that I can do this in such a way that the publications are preserved should the main database fail and the disaster backup be called to action. But how? I don't want to recreate the publications because there a lot of them and it would take several days to recreate the snapshots and re-initialise all subscribers. Can anyone point me in the right direction here?

Acceptable Use Policy