Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

SQL 2008 Replication Monitor showing more publications than exist

We are having issues on our SQL Server 2008 server where more publications are showing up on our Replication monitor than what actually exist.  Some of these are old jobs and some of them appear to be duplicates.  Below is a screenshot of the Replication Monitor showing publications beside those shown in the Management Studio's Replication folder.

replication
How can we resolve this issue?
0
canuckconsulting
Asked:
canuckconsulting
  • 3
  • 3
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Seems like old replications wasn't remove properly.
You can try to delete them. Check also for old SQL Agent jobs and if you find them, also delete it.
0
 
canuckconsultingAuthor Commented:
How can I delete them Vitor?  I can't do it via Replication Monitor and they aren't showing in the Publications folder of Management Studio.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Try:
exec sp_droppublication @publication = N'PublicationName'

Open in new window

0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
canuckconsultingAuthor Commented:
Thanks.

Ok, I this was unable to find any publications.  In fact in the problem DBs the table syspublications system table does not exist.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You need to review the process you are using for deleting publications. Isn't a clear process for sure.
0
 
canuckconsultingAuthor Commented:
Turns out the related DBs were restoring which I guess explains why they weren't appearing.  Once the restores were complete I was able to log in and delete as you suggested.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now