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 |
|
rlgilby
Starting Member
3 Posts |
 Posted - 2010-12-07 : 12:25:45
|
| Replication was working like it was supposed to prior to a rename of the server. Now after the the rename, the only way replication works is if I manually Reinitialize all Subscriptions.How do I fix that?Is there a way to force a replication without a reinitialize? Because when it reinitialize it drops the tables, then creates them but all the grants are gone. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-07 : 12:37:48
|
| No. When you renamed the server, you should have recreated all the publications and subscriptions.The distributor won't be able to find the subscriber after the rename. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-07 : 12:39:26
|
| Also, if the permissions on subscriber are the same as on publisher, you should have set the "copy permissions" attribute to true.If they aren't, you should have those scripted and ready to apply after anytime you run the snapshot agent. |
|
|
|
rlgilby
Starting Member
3 Posts |
Posted - 2010-12-07 : 12:58:24
|
| Russell,Before we renamed the server we deleted all the publication and subscriptions and started from scratch after the server was renamed.Where do I set the copy permission that you are talking about?Because the permissions should be the same.Rob |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-07 : 13:21:25
|
 |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-07 : 13:29:40
|
| You can also change it not to drop the article when you synch the snapshot. That option is visible in the screenshot above as well. |
|
|
|
rlgilby
Starting Member
3 Posts |
Posted - 2010-12-08 : 08:40:31
|
| Russell,Thanks for your help, I think I have it working. I need to do a little more testing but it seems as if changing the article properties when defining what is to be replicated is solving my problems.Thanks again,Rob |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-08 : 12:43:35
|
| You're welcome. Glad to help. Be sure to come back if you have more questions :) |
|
|
|
|
|
|
Replication only works if I do a reinitialization