March 2, 2006 at 12:59 pm
I took the backup of Transactional Replication Databases and Re-stored on Development Server. The strange thing is, in Replication --> Publications --> publishers are listed automatically. If I try to drop this publishers, it gives an error, I tried different ways but with different errors. So I created publishers again with different names
What's wrong with that.
Thanks is advance.
March 6, 2006 at 8:00 am
This was removed by the editor as SPAM
March 6, 2006 at 11:33 am
The reason for this is that there are replication tables included in the database that was backed up. If you look at the tables, you'll see them. This causes Sql Server to recognize the fact that they were part of replication. However, when it is restored to another server, the other supporting tables in the MSDB are not there, hence the in-ability to delete the publications. This is a common issue with backing up replicated databases, and restoring to another server.
You have two options.
1. Clean up the system replication tables manually by deleting them in the database restored.
2. Shutting down and deleting the publications prior to backing up.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply