SQL 2000 transactional replication is generating snapshot every hour
- From: "Roberto T." <r_t@xxxxxxxxxxxxx>
- Date: Thu, 28 Sep 2006 11:55:17 +0200
I have three SQL 2000 servers, with transactional replication between them
(27GB database, +2GB/month)
SQL1 -> SQL2 -> SQL3
SQL1 is a publisher+distributor
SQL2 subcribed to SQL1, and publisher+distributor for SQL3
SQL3 subscribed to SQL2
Everything is working fine, but in the last week the distribution agents
(run at the publicator) die with timeout very frequentlly (once-twice a day)
I have noticed that when this happens it's at every hour (XX:00 - XX:05),
and at the same time SQL2 is generating a snapshot for every publication it
has. This doesn't happen in SQL1, as it detects in some publications that no
sucriptions nedded reinitialization, but SQL2 is generating a snapshot
(aprox. 2GB) every hour for every publication. SQL1 does the same, but only
for some publication with little articles.
I have disabled the snapshot agents in SQL2 as an temporary solution. Does
anybody know why SQL is generating the snapshot every hour? Where can I find
information about the publication/snapshot?
I have tried to reinitialize a subscription, but once reinitialized the
snapshot is generated again and again.
Thanks in advance, best regards,
Roberto T.
.
- Follow-Ups:
- Re: SQL 2000 transactional replication is generating snapshot every hour
- From: Paul Ibison
- Re: SQL 2000 transactional replication is generating snapshot every hour
- Prev by Date: Re: 'INITCOLVS' is not a recognized built-in function name
- Next by Date: Re: SQL 2000 transactional replication is generating snapshot every hour
- Previous by thread: Re: How to handle replication issues in a production environment
- Next by thread: Re: SQL 2000 transactional replication is generating snapshot every hour
- Index(es):
Relevant Pages
|
