Wednesday, March 7, 2012

Replication

Hello,
Can anybody explain me here or can recommend me a good literature how the
replication works with its corresponding compononents and the course of
events of the replication?
thanks in advance
yours sincerely,
robert
with components i mean the virtual directory, publication, snapshot folder,
subscription, repldata folder in the SQL Server directory, etc...
yours sincerely,
patrick
|||Patrick,
currently books on line (BOL) is the best resource for
this sort of data. I have some links on
www.replicationanswers.com you might find useful.
Finally, keep an eye out for Hilary's book:
http://www.nwsu.com/0974973602p.html.
As for the snapshot folder and the repldata folder -
usually they are one and the same. The repldata folder is
an installation folder and is usually made available as a
share to subscribers. This is the folder that stored the
initial configuration textfiles, and datafiles if
selected. ODBCBCP is used to transfer the data to this
file. On initialization the contents of this folder are
applied to the subscriber by the distribution/merge agent.
Alternative snapshot locations are possible - removable
media such as removable disks, CD-ROMs, or in locations
other than in the default snapshot folder on the
Distributor, such as File Transfer Protocol (FTP) servers
which may be compressed, however the above is the default
behaviour.
HTH,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||are we talking SQL CE or SQL Server? SQL CE has a virtual directory which an
isapi filter runs in. The only other virtual directory used in replication
is when you are downloading a publication using ftp and have defined a
virtual directory on your ftp server.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"robert" <robert@.discussions.microsoft.com> wrote in message
news:553B67F1-EF21-480B-99EF-7EFE5B431313@.microsoft.com...
>
> with components i mean the virtual directory, publication, snapshot
folder,
> subscription, repldata folder in the SQL Server directory, etc...
> yours sincerely,
> patrick

No comments:

Post a Comment