Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Could not connect to 'srvrXYZ' server because 'srvrXYZ' is not defined as a remote server Expand / Collapse
Author
Message
Posted Wednesday, April 24, 2013 10:53 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 25, 2014 3:33 PM
Points: 52, Visits: 809
Hi Experts

I am trying to delete my publication from my Publication server and i am getting error. I have already dropped distribution database and none of the jobs are running still I can not drop the Publication. Please help

Screen Short Attached of the problem

Thanks


  Post Attachments 
SQL REPLICATION.jpg (4 views, 233.74 KB)
Post #1446290
Posted Thursday, April 25, 2013 1:19 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 5:30 AM
Points: 811, Visits: 1,165
try this..
sp_droppublication @publication='publicationName', @ignore_distributor = 1
Post #1446685
Posted Thursday, April 25, 2013 1:32 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 25, 2014 3:33 PM
Points: 52, Visits: 809
Giving error

Can not drop the Publication because at least one Subscription exists for this Publication.
Drop all Subscription to the Publication before attempting to drop the Publication.


Now I am getting this error . I never made any Subscription on my Subscription database.
Post #1446689
Posted Thursday, April 25, 2013 1:38 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 5:30 AM
Points: 811, Visits: 1,165
Check under replication "Local Subscription"? Is there any?
Post #1446690
Posted Thursday, April 25, 2013 1:47 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 25, 2014 3:33 PM
Points: 52, Visits: 809
No there is no Subscriptions there
Post #1446695
Posted Thursday, April 25, 2013 1:56 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 5:30 AM
Points: 811, Visits: 1,165
Do you see anything under Local Publication then Publication and click on + of publication..If yes try the below mentioned command..

USE master
EXEC sp_removedbreplication @dbname='DBName'
GO
sp_dropsubscription @subscriber='SubscriptionName'-- If you find anything under +

sp_droppublication 'PublicationName'
Post #1446699
Posted Thursday, April 25, 2013 2:17 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 25, 2014 3:33 PM
Points: 52, Visits: 809
So I was able to remove the replication that command went fine, but there is no subscription & Publication is still there.
Post #1446711
Posted Thursday, April 25, 2013 2:22 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 5:30 AM
Points: 811, Visits: 1,165
Glad it worked for you.
Post #1446712
Posted Thursday, April 25, 2013 2:30 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 25, 2014 3:33 PM
Points: 52, Visits: 809
Thanks A lot
Post #1446716
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse