February 26, 2008 at 12:06 am
Comments posted to this topic are about the item Snapshots - Part 1
February 26, 2008 at 12:52 am
Thanks for the article, very informative.
Just a question. I need to create a SnapShot on Publisher, copy via mem stick to Subscriber. How can i apply snapshot? I cant use the distributoin agent as the link between servers is over a WAN and is slow...
thanks in anticipation
Daryn
February 26, 2008 at 2:04 am
Hi Andy,
Thanks for your article, it's well explained.
Is there a chance that you will do a part dedicated to "merge" replication between DB and Handhelds?
Cheers,
Jean-Charles
February 26, 2008 at 6:27 am
Daryn, in SQL 2005 there is a feature called init from backup that will help you do it - see another article I wrote for more details http://www.sqlservercentral.com/articles/Replication/61767/[/url]. If you're using SQL 2000 it's harder, but doable. Easy way is to lock everyone out of the publisher db while you get the copy to the subscriber, then start the process. You can also just set up replication to say the data already exists, let the log reader run, but keep the distribution agent stopped. That will pile up commands in the distribution database until you've completed your set up on the subscriber side. Experiment locally to prove the concept before you venture into the WAN scenario just to make practicing cheaper.
February 26, 2008 at 6:29 am
Jean-Charles,
Perhaps! I don't do a lot of work with merge or hand helds, but it shouldn't (one hopes) but that much different. If I get a chance I will dig in to see.
February 26, 2008 at 3:56 pm
Thank you Andy. Nice article. Short and sweet. Looking forward to the rest of them.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply