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

Replication syssubscriptions -with serverid -1 Expand / Collapse
Author
Message
Posted Thursday, February 13, 2014 6:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 8:20 AM
Points: 177, Visits: 638
Hi,

When I query Syssubscriptions view I get records with serverid -1 and it seems these records are causing my log agent to fail continuously.

Artid srvrid destdb status
1 -1 virtual 2
2 -1 virtual 2

Can I delete these records from the table?

Thanks,
Hari.
Post #1541156
Posted Friday, February 14, 2014 8:22 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 10:03 AM
Points: 603, Visits: 364
It should be ideally , what you see when query mssubscription for the same database .
Post #1541621
Posted Monday, February 17, 2014 6:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 5:24 AM
Points: 194, Visits: 755
Don't delete them. Those are virtual servers. They are created as part of normal replication and (seeing as they are normal) are unlikely to be causing your problem.

You'll have to do a search to find the explanation of them but I looked into what they were end of last year.
Post #1542078
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse