mahanare
October 28th, 2006, 08:30 AM
Hi,
I have a query about MSCS.
Is it possible to have 2 SQL servers (on different physical machines) and still active?
for now i am not bothered about the passive nodes which work as failure.
What i am intended do is that, i will have 2 SQL servers across WAN (US and Europe) within the client network.
If there is a DB request from US then the US server should attend and similarly Europe server should be available for Europe request.
The point i am making here is that, i am having 2 exact repica of the database at different locations. And any change in one database should take place in other database too.
Is this possible?
Please advice
Harinath
I have a query about MSCS.
Is it possible to have 2 SQL servers (on different physical machines) and still active?
for now i am not bothered about the passive nodes which work as failure.
What i am intended do is that, i will have 2 SQL servers across WAN (US and Europe) within the client network.
If there is a DB request from US then the US server should attend and similarly Europe server should be available for Europe request.
The point i am making here is that, i am having 2 exact repica of the database at different locations. And any change in one database should take place in other database too.
Is this possible?
Please advice
Harinath