all groups > sql server replication > march 2007 >
You're in the

sql server replication

group:

snapshot obsolete


snapshot obsolete Darin
3/19/2007 3:06:38 PM
sql server replication:
SQL Server 2000 sp4 on Windows 2003

All of a sudden, receving error message:

The snapshot for this publication has become obsolete. The snapshot
agent needs to be run again before the subscription can be synchrnoized.

The snapshot was run on 11/27/06 and hasn't been run again (no need to
because the replication is continuous). The schedule for the snapshot is
set to enabled=NO, so it won't be run again.

Why would they be receiving this message now?

Darin

Re: snapshot obsolete Paul Ibison
3/20/2007 12:00:00 AM
It looks like one of your subscriptions has exceeded the subscription
expiration period and therefore is set for reinitialization.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Re: snapshot obsolete Darin
3/20/2007 4:25:41 AM
Ok. So that must be on the property of the subscription. Can I change
that so the subscription hasn't expired so it doesn't want to reinit the
subscription?

I found the publication properties had an option for the subscription to
expire in 14 days. I changed that so the option marked is subscription
never expires. When I start synchornizing, it is now applying scripts
for the tables. And the started bulk copying the data. That seems VERY
incorrect to me since the subscribers data hasn't been put on the
distributor.

My problem is this was discovered yesterday morning. And since then all
3 sites have been up and working entering data. Therefore,
reinitializing the snapshot is not viable because the distributor
doesn't have all of the data from the clients.

HELP.

Darin

AddThis Social Bookmark Button