Pull:shared agent

I had a problem and lost, with no backups, a couple of data bases.
When I was recreating the subscriptions, a subscription just appeared
the name is 'ServerName:database' & the type is 'Pull:shared
agent'. I cannot delete the publication, I get the message 'SQL
Server Enterprise Manager could not retrieve information about
subscription ServerName:database' Start, Stop & job History are all
grayed out on the right click.
Now the questions...
What is a Pullshared agent?
How can I delete this?
What is in this subscription?
TIA,
Larry...
If you are not using the independent agent option and you have two
subscriptions to the same publication database, the two subscriptions will
share a single distribution agent.
You should be able to delete it by using exec sp_dropmergepullsubscription
or sp_droppullsubscription. Fill in the details by referencing the
MSsubscription_properties table in your subscription database.
This subscription is really very similar to any other subscription only
there are two of them
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1130782861.818300.175690@.z14g2000cwz.googlegr oups.com...
> I had a problem and lost, with no backups, a couple of data bases.
> When I was recreating the subscriptions, a subscription just appeared
> the name is 'ServerName:database' & the type is 'Pull:shared
> agent'. I cannot delete the publication, I get the message 'SQL
> Server Enterprise Manager could not retrieve information about
> subscription ServerName:database' Start, Stop & job History are all
> grayed out on the right click.
> Now the questions...
> What is a Pullshared agent?
> How can I delete this?
> What is in this subscription?
>
> TIA,
> Larry...
>
|||Where is this decided independent agent or shared agent? I have
created many many agents and never recall seeing this..