Tuesday, November 5, 2013

Can not rename the database name because it is published or it is a distribution database used by replication. (Microsoft SQL Server, Error: 18855

Today i was on a corruption issue, and i had to rename a database and when attempted to restore the database i got the below error message.

Error Message:

 ==================================
Can not rename the database name because it is published or it is a distribution database used by replication. (Microsoft SQL Server, Error: 18855.

Cause:
====

The newly Created the database is a part of replication confirmed this from the column IS_PUBLISHED of sys.databases system view.

Resolution:
=======

Fixed the issue by Removing the Replication from the database by issuing the below command .

sp_removedbreplication @dbname=name of the db.

No comments:

Post a Comment