sql server replication: We have a user with 3 databases and one subscriber setup for merge, push
subscription.

WHen I connected tonight, it seems the push subscriptions have been
removed, but the snapshot agent is still there.

Is there a way to see when the push subscriptions were deleted? if so,
how? In addition, since they have been running like this for "a while",
if I setup the push subscription again will it "auto" update the
subscriber and vice-versa?

Darin

No, not easily. It looks like someone has gone and deleted the underlying
job from the jobs folder.

You could check

select * from distribution.dbo.MSdistribution_history

to see the last time it ran.

If you recreate the push subscription it should resync the subscriber.

--
relevantNoise - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

The MSDistribution_history was empty.

When I rith-clicked on the publicatoin and selected New Push
Subscription and went through that, I then get:

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

I ran the snapshot agent to recreate the snapshot, then started the push
subscription agent, and it says no data needed to be merged. I know that
can't be the case because even our log table would need to be merged.

So, it seems just recreating the subscription will not re-sync the data
unless there is another way I can do it.

Darin

I just noticed on the Publication Properties that it has marked the
subscription will expire and may be dropped if not synchrnoized in 14
days.

I take that to mean if there was an error between the 2 machines (like
the subscriber internet cut) for more than 14 days, this situation would
occur - the subscription deleted just like I am seeing.

Darin

i just noticed the subscription properties says the subscription will
expire and be removed in 14 if not synchronized. I take that to mean if
the subscribers internet was down for more than 14 days, the
subscription could be deleted, just like I am seeing. Right?

Darin

That is correct, or if it has been offline more than the history retention
period.

--
relevantNoise - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]