SQL Server High Availability Options
Can I implement a high availability solution for one of my SQL Server databases, but I'm not sure of which option to implement to satisfy my company's
needs?
September 15th, 2015 1:13am
AlwaysON is a new feature shipping with SQL Server 2012 and is an alternative to database mirroring. AlwaysON uses groups called Availability Groups, which are groups that contain selected databases that will fail over together if a failure should occur
Free Windows Admin Tool Kit Click here and download it now
September 15th, 2015 2:17am
There are different types of high availability solutions. This depends on your RTO & RPO.
simple words how much data loss can you afford and how much Down time can you afford.
Depending on your requirement you can implement any of the below solutions.
1) Logshipping
2) Mirroring
3) Replication
4) Clustering
5) Always On availability groups.
These features are not available in all versions and editions of SQL server. So all of these solutions may not suitable to your organisation.
September 15th, 2015 2:33am
Can I implement a high availability solution for one of my SQL Server databases, but I'm not sure of which option to implement to satisfy my company's needs?
Well your question is too open ended you have to tell us about your environment so that we can suggest you appropriate solution.
You have lot off options like mirroring, AOAG, Clustering , Logshipping but what you can use depends on version edition and
Free Windows Admin Tool Kit Click here and download it now
September 15th, 2015 3:24am
Other recent topics
