April 24, 2009 at 5:18 am
On one of my servers (sql server 2000) I have 2 databases to dismiss since no more in use. Both were replicated to another server. From Replication\Publications I selected the Subscription and dropped it. Then I deleted the Publication. I verified the jobs releted to snapshot and distribution were deleted, and I thought I had removed the whole replication, and I put the databases offline. The Expired subscription clean up job gives the following error:
Executed as user: web. Database 'MyDatabase' cannot be opened because it is offline. [SQLSTATE 42000] (Error 942). The step failed.
It seems the dbs are still seen as replicated, as they have the same icon (the hand, such as for sharing folders) as other replicated databases.
I've tried to clean using the command
USE 'MyDatabase'
EXEC sp_dropmergepullsubscription
@publisher_db = @publisher_db,
@publication = @publication,
@publisher = @publisher
GO
but it found nothing to clean.
So what can I do?
Thanks in advance for your reply,
sb
April 24, 2009 at 9:00 am
SB,
Have you tried running sp_removedbreplication on both the publisher and subscriber?
-Tom
April 29, 2009 at 3:40 am
Thanks a lot, Tom, it worked!
sb
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply