June 27, 2007 at 2:38 am
Recently I move a rather large database (100GB) to another server for diskspace reasons. I did this by establishing a mirror to the new server, failing the mirror over to the new server (while changing settings in the application) and finally removing mirroring. That went well, less than a minute downtime.
However the database on the old server had transactional replication configured to another server for redundancy and reporting reasons. The new server had no replication configured. It seems that some of the publication information came over with the mirror. There are publications on the new server (with the old server name) that I cannot seem to delete. In addition I also cannot initiate replication on the new server. On top of that, the transaction log keeps growing because it still thinks that replication is active and the logs aren't getting truncated despite transactionlog backups. When I query:
select log_reuse_wait, log_reuse_wait_desc from sys.databases
It gives reason 6 and description REPLICATION
When I try to delete the old publication I get the error: Cannot find stored procedure ''.
When I try to disable publishing and distribution altogether it gives the same error as well as: The distributor has not been installed correctly. Could not disable the database for publishing.
If it is necessary to shut the database down, I would like to have that period as short as possible. Anybody any idea?
June 27, 2007 at 11:46 am
If you have decided to remove replication settings try:
sp_removedbreplication @dbname = 'dbname'
On the publisher database.
Cheers,
* Noel
June 28, 2007 at 6:41 am
Thanks, the sp_removedbreplication did the trick! It removed the existing publications that I could not remove using the GUI. After that I could disable Publishing and Distribution as well. I'll make transaction log backups and see if the log files stop growing. After that I will reintroduce replication.
June 28, 2007 at 10:38 am
Glad to help. You should be fine!
* Noel
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply