[dba-SQLServer] Mirrored servers

John,
  You want to read the section in BOL for database mirroring (btw, its
very cool). Keep in mind it could be most instrumental to have a
seperate pc as the witness that way you won't have to worry about
loosing the witness if server a dies but b is alive and well.




On 3/13/08, jwcolby <jwcolby at colbyconsulting.com> wrote:
> 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
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>

-- 
Sent from Gmail for mobile | mobile.google.com

-Francisco
http://sqlthis.blogspot.com | Tsql and More...