[dba-SQLServer] Mirrored servers

jwcolby jwcolby at colbyconsulting.com
Thu Mar 13 10:59:17 CDT 2008


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
www.ColbyConsulting.com 




More information about the dba-SQLServer mailing list