Re: Transactional replication

One of my friend asked me these questions, I am not sure what his intension
is, Anyway thanks for your help; I;'ll revert back to you after his reply

"Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx> wrote in message
news:OMhSshadGHA.2188@xxxxxxxxxxxxxxxxxxxxxxx
Pull will allow the local subscriber to control synchronization.
The publication will exist only on the publisher (RemoteServer).
The snapshot folder will be defined on the distributor or you can use an
alternative snapshot location as defined on the publication - could be a
network share which would allow you to have the snapshot files held
locally.
However I am not too sure why you would need this?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)




.

Relevant Pages

  • Re: Replication Errors running SQL Server 2005 beta
    ... >> I should have an initial publication. ... >> sure the snapshot was created. ... The Snapshot Agent will run under the Administrator account. ... >> running SQL Server, ...
    (microsoft.public.sqlserver.ce)
  • Re: install/configure SQL Server 2000, SQL Server CE for merge rep
    ... Publication: NorthwindProducts ... PublisherDB: Northwind ... A snapshot of 1 articlewas generated. ... > check the replication monitor in SQL Server 2000 Enterprise Manager ...
    (microsoft.public.sqlserver.ce)
  • Re: Replication Errors running SQL Server 2005 beta
    ... I should have an initial publication. ... sure the snapshot was created. ... running SQL Server, ... The agent generated the snapshot. ...
    (microsoft.public.sqlserver.ce)
  • Re: Snapshot agent doesnt pick new articles
    ... subscription for a single article when the publication is configured to use ... subscription without the new article). ... snapshot agent should generate snapshot for the new article after that. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Starting Snapshot Agent causes the DB machine to hang
    ... locking which can occur when your snapshot it being generated. ... Looking for a SQL Server replication book? ... When I try to start the snapshot agent for a transactional publication it ... Also on the machine that hangs, if I have a console logged in with task ...
    (microsoft.public.sqlserver.replication)