Snapshot replication involving large table - 17million+ rows
- From: quackhandle1975@xxxxxxxxxxx
- Date: 6 Jul 2005 03:26:50 -0700
Hi,
I am looking at Snapshot Replication for an MIS system I have built.
Server1 contains 3 databases and I want to replicate tables from these
databases and publish them to a single MIS database on Server2. I
would only have to run the snapshot once a day. All good so far. The
only issue is that one of the tables I want to replicate contains
approx. 17.5 million rows. I have had issues in the past with the size
of the snapshot file when replicating large tables. What is the size
limit of a snapshot file? I did think it was 2.5GB however that may
have been due to the limitations of the system I was working on (ie -
the snapshot file grew to 2.5GB then replication hung indefinitely).
With large tables I know is it always better to bcp the table first to
the subscriber database then apply the replication however would the
snapshot only replicate rows that have have been changed/added to the
publishing database? That table performs many transactions in a day
(over 50k rows added + 200k transactions) Obviously I don't want it to
always copy the entire table everytime the snapshot runs.
Thanking you in advance,
Regards
qh
.
- Follow-Ups:
- RE: Snapshot replication involving large table - 17million+ rows
- From: Raymond Mak [MSFT]
- Re: Snapshot replication involving large table - 17million+ rows
- From: Hilary Cotter
- RE: Snapshot replication involving large table - 17million+ rows
- From: Christian Donner
- RE: Snapshot replication involving large table - 17million+ rows
- Prev by Date: RE: How to check sql server at distributor , publisher and subscri
- Next by Date: Re: Merge replication in 'SQL Server'
- Previous by thread: How to check sql server at distributor , publisher and subscriber
- Next by thread: RE: Snapshot replication involving large table - 17million+ rows
- Index(es):
Relevant Pages
|
