Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ServerTeam
Yak Posting Veteran
83 Posts |
 Posted - 2008-10-08 : 07:42:43
|
| Hi Gurus,I am facing issue with 1 scription on my publication.Actually it has 4 subscription.Other 3 has no issues.One of the subscription shows status as Not RunningOther 3 shows status as RunningWhen i right click on replication monition on my subscriptions its giving me option as to Reinitilaze Subscription.My question here is can i Reinitilaze Subscription ?Please help me ..Thanks,ServerTeam |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-08 : 08:32:44
|
| Did you figure out why it is not running? Check job status for subscriber. Looks like your subscription is expired. You have to reinitialize for it to work. Also donot set expiry on Subscription. |
 |
|
|
ServerTeam
Yak Posting Veteran
83 Posts |
Posted - 2008-10-08 : 09:28:04
|
quote:
Originally posted by sodeep
Did you figure out why it is not running? Check job status for subscriber. Looks like your subscription is expired. You have to reinitialize for it to work. Also donot set expiry on Subscription.
Expiry was not set on subscription.Last status i see as Subscription was sucessfully stopped..Thanks,ServerTeam |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-10-15 : 14:02:51
|
| I faced this kind of problem when we lost communication between the servers.Subscription was stopped.We have to restart the subscription. |
|
|
|
|
|
|
Issue with 1 subscription