Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Snapshots - Part 1 Expand / Collapse
Author
Message
Posted Tuesday, February 26, 2008 12:06 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Thursday, December 18, 2014 6:56 AM
Points: 6,804, Visits: 1,934
Comments posted to this topic are about the item Snapshots - Part 1

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #460077
Posted Tuesday, February 26, 2008 12:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 23, 2008 6:21 AM
Points: 1, Visits: 9
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
Post #460089
Posted Tuesday, February 26, 2008 2:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 6, 2009 12:27 PM
Points: 1, Visits: 11
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
Post #460100
Posted Tuesday, February 26, 2008 6:27 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Thursday, December 18, 2014 6:56 AM
Points: 6,804, Visits: 1,934
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/. 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.


Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #460191
Posted Tuesday, February 26, 2008 6:29 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Thursday, December 18, 2014 6:56 AM
Points: 6,804, Visits: 1,934
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.


Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #460192
Posted Tuesday, February 26, 2008 3:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 28, 2008 2:59 PM
Points: 6, Visits: 27
Thank you Andy. Nice article. Short and sweet. Looking forward to the rest of them.
Post #460596
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse