Hello
I'm working a website that is going to be very,very critical. For now, there is one MSSQL 2005 database online. I'm trying to figure out how to setup mirroring for two MSSQL Servers. (Like two mirrored servers)
I understand that you can setup a mirroring like "Server", "Server backup" and "Witness" and the witness then checks if Server is offline. If Server is offline, then the Server backup is used until Server is online again.
But I want this scenario:
ONE domain like servers.com (not my domain, I wish though ;-))
Server1 and Server2 could be located at totally different geographical locations.
Server1 on network1
Server2 on network2
When Server1 goes offline (for example if the internetoperator goes down for network1), Server2 on network2 should be activated for the domain servers.com
When Server2 goes offline (for example if the internetoperator goes down for network2), Server1 on network1 should be activated for the domain servers.com
Is it possible to do this with MSSQL ?