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