sql server replication: Hi all,
I've 2 servers with 2 db that must have the same data...
I'm studing how to make replication, but is very difficult
for a novice.
The connection between the servers is 24h.
There some good book with samples step by step (for
dummies)?
thanks for any idea
--

http://www.mssqlserver.com/replication

When you set this up, do everything on a single machine. Why? The two
things that cause the greatest problems with replication are security and
connectivity. You rule both out on a single machine and can spend your time
getting comfortable with replication before you move to a multi-machine
environment.

--

Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

Dipic,
there aren't any books particular to sql server replication, although I have
heard there will be two volumes coming out in the near future....
For now, I'd use books-on-line as your main resource, and there is a lot of
useful information there.
You have to consider if the subscribers can change the data and the degree
of latency allowed/accepted. This will narrow down your choices. BTW,
replication is not the same as database mirroring (see SQL 2005), so there
will always be some latency involved.
Post up in this group as much as you can - there are plenty of people here
with a lot of experience, and this will speed up your learning.
HTH,
Paul Ibison

Both dbase are alive... people work on the first and on
the second server, and all must have the same data every
12h ca.

[quoted text, click to view]
would be your live database and the other would be just
for backup , is that the case then you can got for
Transactional replication where incremenatal data would be
copied on to other server
[quoted text, click to view]