Offline Synchronization in SQL 2008R2

  • It has been a long day, so I am hoping I missed this in the BOL and web searches.

    We have two SQL Server 2008 R2 Enterprise installations (Philadelphia and Boston). The link between them is not good (one hop is probably 20 MB available bandwidth). Our database is 300 GB. We are transferring operations from Philadelphia to Boston and wanted to set up replication to manage the data updates while everything is tested and we get ready to perform the switchover.

    Problem... I can not use standard synchronization process between the distributor and subscriber. Back in SQL 2000 we were able to take a backup of the distribution database, restore it to the subscriber and then let the system catch up on transactions. I can not find this capability. Does it still exist? Where can I find the details on it?

    Thanks

    Raymond Laubert
    Exceptional DBA of 2009 Finalist
    MCT, MCDBA, MCITP:SQL 2005 Admin,
    MCSE, OCP:10g

  • Perhaps something like this?

    http://msdn.microsoft.com/en-us/library/ms151705.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply