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 |
|
shobhaaradhya
Starting Member
37 Posts |
 Posted - 2013-02-04 : 03:47:47
|
| Hi, I would like to know if I change the no of days in publication properties in General tab "Subscription expire and may be dropped if not synchronized in the following number of days. Replication meta data is kept for this amount of time". Will the subscription be reinitialised? If so how can I avoid reinitialising the subscriber when I change the number of days?Thanks in advance,Aradhya |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-02-04 : 17:09:28
|
| Changing that will not reinitialize the subscriptions. If your replication is currently broken for some reason though and you change that value to be a shorter duration than how long it has been broken then your subscription(s) will be dropped.Be One with the OptimizerTG |
 |
|
|
shobhaaradhya
Starting Member
37 Posts |
Posted - 2013-02-05 : 05:05:27
|
| Hi, Thanks for the reply. Will the changes affect both new and existing subscriber?Thanks,Aradhya |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-02-05 : 09:59:11
|
| Of that publication, yes.Be One with the OptimizerTG |
|
|
|
|
|
|
changing subscription expiration