October 6, 2006 at 12:53 pm
I have setup transactional replication. Now I want to rename the Subscriber database without breaking replication.
Here is what I did so far
1. Stopped Distribution Agent
2. Renamed the Subscriber Database
3. Changed the SubscriberDB parameter to the new database name in the distribution job.
4. Changed the Subscriber_db in the MSsubscriptions and MS_DistributionAgents tables on the distribution database
5. restarted distribtuion.
The distribution started successfully, but no transactions are going through.
Are there more system areas that need to be changed?
October 9, 2006 at 8:00 am
This was removed by the editor as SPAM
October 9, 2006 at 8:52 am
There's also the syssubscriptions table in the publication database that references the subscription database name. Trying to change things this way sounds frought with problems. i think you'd be better off deleting the subscription, renaming the DB, then creating a new subscription.
October 15, 2006 at 1:26 pm
Are you sure your Log Reader Agent start?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply