Link to home
Start Free TrialLog in
Avatar of rutgermons
rutgermons

asked on

high availability on sql server

folks

does SQL Server provide a cluster failover mechanism or some form of real time replication similar to oracles active data guard?

we are looking to deploy sql on physical hardware but with limitations that the storage will only be local and need some clues or guidances
SOLUTION
Avatar of Deepak Chauhan
Deepak Chauhan
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@but with limitations that the storage will only be local and need some clues or guidances.

In this case you can configure SQL server Transactional replication between two sql server instances.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial