August 5, 2005 at 12:34 pm
I wrote some scripts to report on my replication jobs, and noticed that one table isn't showing up on my report. After digging a bit, I find that it's because the only entry in syssubscriptions has SRVID = -1 and DEST_DB = 'virtual'. All the other subscriptions have 2 records in syssubscriptions, one with SRVID = -1 and DEST_DB = 'virtual', and a second row with SRVID = 2 (server id) and DEST_DB = 'AdvDbWhs' (my subscriber DB).
I dropped the publication, and recreated it and the subscriber, but I still only get that 1 "virtual" record in syssubscriptions.
So, what action will create a syssubscriptions record with srvid = 2 and dest_db = 'my dest database' like all the other ones ?? I will create the snapshot tomorrow when there are no locks on the table. I'm pretty sure that this publication and subscription are the same format as all the others.
Any thoughts on why this is ?
August 8, 2005 at 9:36 am
I think this was caused by me accidentally creating the subscription as an anonymous pull subscription. I dropped it & created it as a named pull subscription and now it matches the others.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply