[dba-SQLServer] SQL Server Database Replication Between Two Servers

Paul Hartland Paul.Hartland at orridge.co.uk
Tue Jan 31 06:06:57 CST 2006

To all,

We have two servers (for the purpose of security lets call them SRV_1
and SRV_2) which both have a copy of SQL Server 2000 on them, onto which
I have placed a test database (Dbase_Rep).  When a user updates the
database on SRV_1 I need the changes to also be made on SRV_2 either
instantly or at a desired time interval.  I know this can be done and
have had a quick play and almost got it there.

Does anyone have an idiot proof step by step guide starting from scratch
or know where I can get one from.

Thanks in advance for any help on this. 

Database Designer/Programmer
paul.hartland at orridge.co.uk
DDI - 01922 472031
Mobile - 07730 523179


*  This message is confidential.
*  This email, its content and any files transmitted with it are intended solely for the addressee and may be legally privileged and/or confidential.
*  Access by any other party is unauthorised without the express written permission of the sender.
*  If you have received this email in error you may not copy or use the contents, attachments or information in any way and any review, use, dissemination, forwarding, disclosure, alteration, printing of this information is strictly prohibited. Please destroy it and notify the sender via return e-mail.
*  This email has been prepared using information believed by Paul Hartland to be reliable and accurate, but the company makes no warranty as to accuracy or completeness. In particular the author does not accept responsibility for changes made to this email after it was sent.
*  Any opinions expressed in this document are those of the author and do not necessarily reflect the opinions of the company or its affiliates.

The Orridge web site can be found at:

More information about the dba-SQLServer mailing list