.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Replication Monitor shows old publication

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :

So, I am using Replication monitor, and under one of my publisher nodes, I still see an old publication, which I do not see in SSMS Object explorer.  This publication shows a red 'x', and I can't view the properties.  I've tried using 'sp_droppublication' at the publisher, 'sp_dropsubscription' at the publisher, 'sp_droppullsubscription' at the subscriber, and 'sp_subscription_cleanup' at the subscriber.

Any ideas on how to get rid of this?  It's making the publisher node show a red 'x' also, which is misleading.  Thanks!


View Complete Post

More Related Resource Links

Replication Monitor: Publication Node will not expand



I'm using SQL Server 2005 Replication Monitor to monitor a number of Publications.

One Publication node, will not expand however, that is to say that when clicked it's label changes to expanding and then never actually completes in order to provide details of the Publications at the Publisher. This means that I cannot highlight a specific Publication at the Publisher for further investigation and instead have to review all Subscriptions in the subscription watch list, which is cumbersome.

I have tried removing the Publication and adding it back to Replication Monitor without success, the issue persists. I have also tried creating a SQL Server Login with SYSDBA rights in order to connect to the remote distributor in order to rule out a permissions issue.

Has anyone else come across this issue before or can perhaps provide further suggestions in order to troubleshoot?

John Sansom | SQL Server Database Administrator

Give non-SA Access to Replication Monitor - SQL 2008

I need to give a user access to Replication Monitor in SQL 2008. How can I do this without giving them SA access ?  

Replication Monitor - Friendly Name

Anyone know how to get this field to populate from a given subscription in Merge replication?

Dropping a column in publication without affecting transactional replication

I have set up Transactional Replication ONLY from database A  in server 1 (Publisher) to Database B in server 2 (Subscriber). I didnt set up snapshot replication but the database B was restored after taking backup of database A. Replication is fine now. But, I need to drop one column which is a primary key in one table(foreign key in another table :)) in Publisher without causing any issues to the replication. BTW, I am using SQL SERVER 2008 R2. Can someone please tell me how to do this?

Replication Monitor Problem


I tried to monitor the replication by running the query.



* FROM [distribution].dbo.MSreplication_monitordata

Now, one distribution agent is failed; however the status returned by the query doesn't show that. It is idle instead of failed. Do you know why this happens? What's the best way to monitor automatically?


Replication monitor could not conenct to distributor



In our environment we are maintaining Transactional replication between 2 servers.

Both  servers are sql server 2005 with standard edittion.

By  launching replication monitor in  server 1  we can see both the servers publisher status.

But i found that server 2 publisher  is not able  to connect with distributor.I tried to connect to distributor.Here i am getting error like

Replication monitor could not connect to distributor of server 2.

Failed to connect to server 2 (Microsoft .Sqlserver.Conenctioninfo)

Login failed for user " .The user is not associated with a trusted sql server conenction .(Microsoft sql server ,error :18452)

Kindly help me to find out the exact rootcause.



Latency on Replication Monitor(Transactional Replication)


Latency shows around 18 hrs today on the replication monitor and status shows Performance critical.Is that mean the subscriber is 18 hrs latency when compared to the publisher?Will it catch up eventually?

Thanks In advance.

Cannot open replication monitor in a distributed scenario



I have created a replication topology on 2 servers. The distributor is located on the subscriber in order to reduce server load on the publisher. The publisher is a Sql Server 2005, the subscriber & distributor is Sql Server 2008.

When I want to examine the replication with replication monitor, I have to do this at the publisher. If I try to view synchronization status at the subscriber it throws the exception 'You must manage this subscription from the publisher because it shares a distribution agent with subscriptions to other publications from the same publication database.' Also I don't even have the option to call the replication monitor at the subscriber. But when I try to open a replication monitor at the publisher, it isn't able to connect to the distributor because it is Sql Server 2008.

Is there any way I can use the replication monitor in my deployment scenario?

Greets, Stefan

Initial SQL Server replication over https fails with "subscription to publication 'xxx' has expire


Set up

SQL Server 2008 standard 64-bit on machine A, acting as both publisher and distributor (Windows 7 Professional 64-bit)

IIS 7 on machine B in same domain as machine A (Windows Server 2008 R2 Standard 64-bit).

Subscriber running on Sql 2008 Express on notebook running Windows 7 home, does not belong to any domain

If I hook up the notebook to the internal network, and use the SSMS "New Subscription Wizard", everything works correctly (I connect to the publisher using an SQL account)

If I then delete the subscribtion on the notebook, and recreate it on the notebook outside the firewall (using the script generated by the wizard in the step above), and initialize the replication from outside the firewall it STILL works correctly.

However ...

If I create a new publication on the publisher, and try to initialize the replication on the subscriber outside the firewall (using the same script from the wizard), I get the error noted in the title.

Again, I am using a script to create the subscription which was generated by the new Subscription Wizard, and I am running the same batch file on the subscriber to run replmerg.exe to initiate / replicate in both scenarios.

So, as far as I can see, everything is identical, including all the security accounts used.

It seems that somehow

Replication Monitor losing connection to distributor


We are having an issue with our replicaiton monitor.  Upon opening the monitor it shows the publisher with a red x next to it.  After right clicking and connecting to the distributor it shows the publications in the tree view, but not in the publications tab.  Of course, after the refresh (default 5 seconds) it loses its connection again.  If I change the default refresh time, it stays connected and I can browse some of the data.  But the publications are still not listed when the publisher is selected in the tree view.  Any thoughts on why it would do this and what we can do to resolve the issue?



TSQL to know there is an error in replication monitor (red X)


In SQL 2005 and SQL 2008, in the Replication Monitor it will show a red X if any of the subscriptions have an error. Is there a TSQL statement i can run to see that without having to go into the Replication Monitor?

i am trying to come up with some way to see that information and present it to our customer from our application without them having to connect to SSMS and look at the replication monitor.

thanks for you help.


Issue while Adding article in existing publication Transactional Replication.


We are facing difficulties adding article to an existing publication.The replication was setup by restoring the backup on subscriber  from publisher and changed the setting Intilialize from Backup =True

Used the following steps but it almost bought down the system.




@publication = N'marcus8rpl',

Merge Replication - Add table to existing publication


I added a table to an existing publication and then generated a new shapshot.  The merge agents then sent the new table and data down to the sunscribers as planned.  The issue is that at the next cycle the merge agent re-initilizes the table again.  This happens over and over again.  If I stop and restart the agent I can watch it send the schema back down to the subscriber.  Any thoughts are appreciated.



Replication Monitor Error



after updating a SQL Server 2008 (German) installation to SQL Server 2008 R2 (English), I get an error when I connect to the distributor by using the replication monitor on the same machine. I deinstalled the old version and made a complete new installation.

the error message is: "an error occurd while retrieving the puplisher data" and "Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt"

The last massage is in german, which means translated: "Object reference not set to an instance of an object"

When I open the distributor on this machine from an other machine everthing is fine.

I believe, there is somewhere a library which is still from the previous installation. But where?

Thats how it look like: http://ausgelesenes.de/rm_error.jpg

Server Info ===========================

Microsoft SQL Server Management Studio                        10.50.1600.1
Microsoft Analysis Services Client Tools                        10.50.1600.1
Microsoft Data Access Components (MDAC)                        3.86.3959

Build succeeded but still shows as failed.


 I am able to run a build successfully on just the web site, but when i add the deployment project it shows failed (see below) but in the details it says build succeeded for the WDP build portion...so I am stumped as to by I am getting a failure. any ideas? I have set the build output to "Diagnostic" and dont see any failures or errors...so is there anything else i can do to find the problem?


Build succeeded.

Time Elapsed 00:00:21.71
------ Skipped Rebuild All: Project: AdminToolHelp, Configuration: Debug Any CPU ------
Project not selected to build for this solution configuration
========== Rebuild All: 1 succeeded, 1 failed, 1 skipped ==========

Toolbox: Easy File Backup, Exploring Files And Folders Inside Visual Studio, Multiple Monitor Softwa


If the responsibility for creating, managing, and executing routine backups is yours, these tools will make it easier. Also see how you can browse folders and files from inside Visual Studio.

Scott Mitchell

MSDN Magazine May 2009

.NET Matters: Deadlock monitor


This month Stephen Toub discusses deadlocks that can occur when synchronizing threads.

Stephen Toub

MSDN Magazine October 2007

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend