RE: syssubscriptions w/ dest_db = 'virtual'

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.


Raymond Mak [MSFT] wrote:
>Hi Gabriel,
>
>Subscriptions with destdb = 'virtual' and srvid = -1 (or virtual
>subscriptions) will be created if you set the immediate_sync publication
>property to true. This is typically the case if you set up the
>transactional\snapshot publication to allow anonymous subscriptions. What
>setting immediate_sync to true means is that you want a generated snapshot to
>be available for initializing subsequently added subscriptions (or
>subscriptions added after the snapshot has been generated). As such, you can
>think of the virtual subscriptions as placeholders for referencing a
>generated snapshot so it won't get clean up immediately by the distribution
>cleanup agent.
>
>-Raymond
>
>"Gabriel D via SQLMonster.com" wrote:
>
>> 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
>[quoted text clipped - 7 lines]
>>
>> Any thoughts on why this is ?


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-replication/200508/1
.

Relevant Pages

  • Re: @post_snapshot_script
    ... deployed subscriptions. ... Looking for a SQL Server replication book? ... I have a transactional publication in SQL 2000. ... Then when I run the snapshot agent, ...
    (microsoft.public.sqlserver.replication)
  • Re: Apply snapshot regularly
    ... If you run the snapshot again the snapshot will only be generated if there ... is a subscription that needs it or if you are using anonymous subscriptions. ... time your snapshot agent runs and be distributed to all of your subscribers. ... So reinitialize is saying this subscriberneeds a new snapshot and the ...
    (microsoft.public.sqlserver.replication)
  • Re: @post_snapshot_script
    ... but use sp_addscriptexec to run the permissions script on all unc ... deployed subscriptions. ... I have a transactional publication in SQL 2000. ... Then when I run the snapshot agent, it only includes the one table in the ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL2005 sp_addsubscription not same as 2000
    ... This applies when the existing publication set up with concurrent ... snapshot option and means that you can't synchronize subscriptions for such ... There are 2 unofficial workarounds: you can circumvent the check by ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge Replication: invalid column name rowguidcol on adding new articles?!?!?
    ... Exactly what do you mean by "recreated my snapshot", ... It sounds like your subscribers are not aware of the added newly articles. ... I'd advise you to drop your subscriptions and publicationand start again ... > I've been running Merge replication successfully now for about 6 months. ...
    (microsoft.public.sqlserver.replication)