March 2, 2007 at 9:37 am
This one is driving me crazy...
We are using Transactional Replication with the subscribers initialized from a backup (no snapshot). It's working great, but now we need to add several new articles to the publication and have them picked up in the subscribers.
The only way I can get this to work is to drop the subscriber, backup the published database, restore the previously made backup over the destination databases and then re-create the subscriptions. There has to be a better way?
I've tried using the sp_reinitializesubscription, but that doesn't work since we aren't using a snapshot. I've tried skipping the restore, and just creating the tables in both the source and destination databases. Doing this, the subscription is re-created sucessfully, but data in the new articles is not actually being replicated.
Replication isn't my forte, and the documentation on initializing with backups is pretty sparse, so any advice is appreciated.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 3, 2007 at 12:46 am
Why you don't want to create new publication with these articles...without effecting existing one...
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply