FIRST 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
dipic
What type of replication r u looking for ? Whether one 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
|||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
|||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
|||Both dbase are alive... people work on the first and on
the second server, and all must have the same data every
12h ca.

>--Original Message--
>What type of replication r u looking for ? Whether one
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
>.
>
|||I've both the dbase alive (people working on), and the
data must be replicated from server1 to server2 and vice
versa, every 12h ca... but I'm totally novice and I don't
know what I must do... I'm searching some example, a
suggestion or a guide...
thanks for your reply

>--Original Message--
>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
>
>.
>
|||http://www.mssqlserver.com/replication
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com