Removing Replication

Question

Removing Replication

sqlstar2011

SSCertifiable

Points: 6000
More actions
February 8, 2007 at 7:59 am

#62535

I stopped the synchronization process at the subscriber and delete it. Removed the publication as well. However there is a icon that appears on the db when replication is setup, which sort of makes it look like a share. How do I get rid of that?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Carlos Pereyra Ten Centuries Points: 1069 More actions · Answer 1

I assume that you have the hand sign that indicates that a database is setup for replication. If so, and you don't want that database to be replicated, you can execute the following:

exec sp_replicationdboption @dbname = N'<yourdatabasename>', @optname = N'publish', @value = N'false'

GO

Replace <yourdatabasename> with the actual database name.

Regards,

Carlos

MohammedU SSCoach Points: 19644 More actions · Answer 2

You removed the subscriptions and publication but db is still enable for replication...

Run the script Corlos suggested or you can use EM to disable replication...

MohammedU
Microsoft SQL Server MVP

sanjeev-406132 Valued Member Points: 55 More actions · Answer 3

Also At publication do this in sequence

EXEC sp_dropsubscriptions ,,,,...............

EXEC sp_droppublication ,,,,,.................

EXEC sp_replicationdboption ,,,,,,,.................... (Set to fasle)

EXEC sp_dropsubscriber

EXEC sp_dropdistributor

and you are done

Thanks

Sanjeev

annejo Ten Centuries Points: 1080 More actions · Answer 4

We've always used sp_removedbreplication 'databasename' on the publisher and subscriber after removing replication. This gets rid of all the replication system objects that often get left behind and the replication icon that appears on the published database.

Anne