Snapshots - Part 1

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Andy Warren » Snapshots - Part 1

Snapshots - Part 1

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Warren

Posted Tuesday, February 26, 2008 12:06 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Comments posted to this topic are about the item Snapshots - Part 1

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #460077

Daryn House

Posted Tuesday, February 26, 2008 12:52 AM

Forum 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

Jean-Charles Sailland

Posted Tuesday, February 26, 2008 2:04 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 06, 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

Andy Warren

Posted Tuesday, February 26, 2008 6:27 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

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
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #460191

Andy Warren

Posted Tuesday, February 26, 2008 6:29 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

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
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #460192

Peter Speltz

Posted Tuesday, February 26, 2008 3:56 PM

Forum 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 »

Permissions