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

Arthur Fuller artful at rogers.com
Sun Feb 26 07:40:50 CST 2006


I've been a bit tardy replying to messages on this list due to work-load,
but if you haven't already had a satisfactory answer, try using a trigger.
You will have to reference the other database explicitly of course, using
the standard dot notation: ServerName.DatabaseName.TableName.
HTH,
Arthur

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Paul
Hartland
Sent: January 31, 2006 7:07 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] SQL Server Database Replication Between Two Servers
Importance: High

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. 

PAUL HARTLAND




More information about the dba-SQLServer mailing list