June 1, 2011 at 1:21 pm
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
June 1, 2011 at 2:12 pm
Perhaps something like this?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply