[dba-SQLServer] Mirrored servers

Asger Blond ab-mi at post3.tele.dk
Thu Mar 13 18:30:19 CDT 2008

Database mirroring is not an option, since you want both databases to be
For the scenario given I would definitely choose replication, and more
specifically: Peer-To-Peer Transactional Replication, which will give you
fully operational databases on both sites and near real-time
Using this type of replication you have to make sure that conflicts can't
arise, since Peer-To-Peer Transaction Replication doesn’t have conflict
resolution, as Merge Replication have. You could choose Merge Replication,
but then you would have latency of synchronization.


-----Oprindelig meddelelse-----
Fra: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af jwcolby
Sendt: 13. marts 2008 16:59
Til: 'Discussion concerning MS SQL Server'
Emne: [dba-SQLServer] Mirrored servers

I have two servers running Windows 2003 and SQL Server 2005.  I would like
to be able to have identical databases on both and work on both
simultaneously, iow "keep them in sync".  If I update a table on ServerA I
need it to update on ServerB.  If I update a table on ServerB I need it to
update on ServerA.

Is this possible?  I do a fair amount of SQL Server stuff now and it is all
running on ServerA.  If it dies, then whatever I did is not on ServerB even
though Server B is capable.  If I somehow cause it to mirror stuff over to
ServerB and then it dies, I could work on ServerB, but when I got ServerA
working again, now I need to get the information synced back to ServerA.

I have read a little about "failover" but that is not precisely what I am
looking for.  I would like to be able to run jobs on ServerA, then while
that is running, run jobs on ServerB.  When each finishes, the results need
to post back to the other server.

Is what I am trying to do possible, and if so where can I go to learn how to
set it up.  

John W. Colby
Colby Consulting

dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com


More information about the dba-SQLServer mailing list