Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Snapshot replication

  
   Database Help (Home) -> Replication RSS
Next:  Master Slave scenario  
Author Message
Rob113

External


Since: Sep 02, 2004
Posts: 54



(Msg. 1) Posted: Tue Mar 25, 2008 8:33 am
Post subject: Snapshot replication
Archived from groups: microsoft>public>sqlserver>replication (more info?)
I really need some help with replication. I have over 150 remote sites with
MSDE db's that I want to replicate back to our headquarters. I want to keep
each db separate but have them on one SQL 2005 server. I don't want to get
into details as to why I'm doing this because it would take days to explain.

I've set up 5 sites as tests. I set up each site as publisher and
distributor. I set up our SQL 2005 box here as subscriber. I want to do
snapshot replication. I set up the snapshots to be done every night and that
part goes off without a hitch.

The problem I'm running into is the pull subscription. I set up the pull to
be schedule through Management Studio. Everything looks right to me, but what
do I know. Anyway, the snapshot gets created but it doesn't get pulled.

Can anyone point me in the right direction? Should I set it up differently?
Help!

 >> Stay informed about: Snapshot replication 
Back to top
Login to vote
Paul Ibison1

External


Since: Mar 01, 2004
Posts: 181



(Msg. 2) Posted: Tue Mar 25, 2008 7:25 pm
Post subject: Re: Snapshot replication [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Rob - what happens when the distribution agent runs - what messages are
returned?
Also, I need to understand why this is not a transactional setup - does each
remote site have different schemas, so there are 150 schemas intended to
arrive on the publisher?
Rgds,
Paul Ibison
(www.replicationanswers.com)

 >> Stay informed about: Snapshot replication 
Back to top
Login to vote
Rob113

External


Since: Sep 02, 2004
Posts: 54



(Msg. 3) Posted: Tue Mar 25, 2008 7:25 pm
Post subject: Re: Snapshot replication [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Can't do transactional...all remote db's are MSDE.

"Paul Ibison" wrote:

> Rob - what happens when the distribution agent runs - what messages are
> returned?
> Also, I need to understand why this is not a transactional setup - does each
> remote site have different schemas, so there are 150 schemas intended to
> arrive on the publisher?
> Rgds,
> Paul Ibison
> (www.replicationanswers.com)
>
>
>
 >> Stay informed about: Snapshot replication 
Back to top
Login to vote
Paul Ibison1

External


Since: Mar 01, 2004
Posts: 181



(Msg. 4) Posted: Tue Mar 25, 2008 8:20 pm
Post subject: Re: Snapshot replication [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
OK - sorry, missed that bit.
What about the other qns - are there 150 schemas, or is the data to be
amalgamated into the same set uf tables?
Also, what messages are returned when the distribution agent runs.
Rgds,
Paul Ibison
(www.replicationanswers.com)
 >> Stay informed about: Snapshot replication 
Back to top
Login to vote
Paul Ibison

External


Since: Apr 04, 2008
Posts: 24



(Msg. 5) Posted: Fri Apr 04, 2008 6:09 am
Post subject: Re: Snapshot replication [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Rob,
this all sounds ok to me. I'm assuming the tables on the publisher are in
separate databases or have different names. You could have used transactional
with queued updating subscribers and then only get the changed data (the
central box is the publisher) or even merge. The latter would be overkill as
you are only pulling data. Anyway, what error are you getting?
Rgds,
Paul Ibison (www.replicationanswers.com)
 >> Stay informed about: Snapshot replication 
Back to top
Login to vote
Rob113

External


Since: Sep 02, 2004
Posts: 54



(Msg. 6) Posted: Fri Apr 04, 2008 7:05 am
Post subject: Re: Snapshot replication [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Paul,

I appreciate your help but I got it. Turns out it was user error on my
part...I set up the scheduled snapshots but didn't enable them. Duh!

"Paul Ibison" wrote:

> Rob,
> this all sounds ok to me. I'm assuming the tables on the publisher are in
> separate databases or have different names. You could have used transactional
> with queued updating subscribers and then only get the changed data (the
> central box is the publisher) or even merge. The latter would be overkill as
> you are only pulling data. Anyway, what error are you getting?
> Rgds,
> Paul Ibison (www.replicationanswers.com)
>
 >> Stay informed about: Snapshot replication 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Replication Snapshot using all the memory. - Hi I am having database size =300 GB and Ram size 32 GB during snapshot in replication it is using all my memory basically it is showing 5 MB during that time my system stop respond for the other instances.I cant allocate fixed memory to each instance...

Problem with activating Snapshot for replication - I am gettin gthe following message, after running a snapshot on my SQL 2000 server. "The concurrent snapshot for publication 'Name' has not been activated by the Log Reader Agent. " I have removed replication and re-created it for this DB se...

Applying initial snapshot for merge replication - Hi, I want to configure a very slow connecting SQL server (coming over the internet) as a subscriber to my merge replication publication. No matter, however number of times I have tried sending the initial snapshot to the subscriber at the stage of..

3930 when pushing subscription to a snapshot replication p.. - We are attempting to use snapshot replication to push data from one SQL Server 2005 server to another SQL Server 2005 server. We had no trouble creating the publication, but when we try to create a new push subscription we get the failure below..

Merge Replication: Would changing the subscriber IP addres.. - Hi, I need to migrate 3 replicated databases to new servers running SQL2K on Windows 2003 standard, each server exist in different state with continues merge replication. Since the Databases around 40GB with big number of BLOBS I'm planning to follow...
   Database Help (Home) -> Replication All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]