I want to enable "AlwaysOn" feature of MS SQL Server 2012 in Windows 8.1
Is it possible to do so?
Sql-server – Can we enable alwayson feature of sql 2012 in windows 8.1
availability-groupsclusteringsql-server-2012windows 8
Related Question
- Sql-server – How to open SQL Server 2008 R2 Configuration manager in Windows 8.1
- Sql-server – SQL Server – Log Shipping Into an AlwaysOn Availability Group
- Sql-server – How to SQL server AlwaysOn AG can be used as a DR feature
- Sql-server – SQL Server 2012 AlwaysOn Availability Group
- Sql-server – Practicing AlwaysOn on SQL Server 2014 – Windows 10 Home
- Sql-server – Always On Availability Groups on Windows 2012 Standard
- Sql-server – Implement SQL Server 2012 AlwaysOn
Best Answer
Short answer is, No.
To enable Sql Server AlwaysOn, the server
Server Clustering is only available on Windows Server OS (i.e. Not 8.1) Windows Server Clustering
You might want to see Overview of AlwaysOn Availability Groups (SQL Server)
Anticipating further questions, you might want to have a look at other disaster recovery options that you might be able to use: Description of disaster recovery options for Microsoft SQL Server Something like log shipping might be the most feasible and easy to set up (assuming you have limited resources, and that's why you have SQL Server installed on Windows 8.1 and not a server)
Edit Without lingering on this too much, for the sake of completeness I'll point out there is a difference between AlwaysOn Availability groups and SQL Server Failover Cluster Instances, discussed here, the former only available on Enterprise edition. Still both dependant on WSFC though so it doesn't make a difference for you.