Configure SQL Server 2012 AlwaysOn High Availability ( cluster SQL without shared storage)

Configure SQL Server 2012 AlwaysOn High Availability

1. Prepare

2. Step by step : Configure AlwaysOn High Availability for DC16 and DC17

- DC16, DC17 : Configure requirements (using account domain running services)

+ Install and configure failover clustering, cluster name named SQLHA IP 10.0.0.100

+ Start - SQL Server Configuration Manager - SQL Server Services - Righ-click "SQL Server (MSSQLSERVER)" - Properties - AlwaysOn High Availability tab

- Tick "Enable AlwaysOn Availability Group" - OK

- DC11 : Create and share a folder named SQLShare

- DC16 : Configure AlwaysOn High Availability

+ Start - Microsoft SQL Server Management Studio - Server name : DC16 - Connect - DC16 (...)

+ Righ-click Databases - New Database... - Database name : DB01 - OK

+ Righ-clik DB01 - Tasks - Back Up... - OK

+ AlwaysOn High Availability - Righ-click Availability Groups - New Availability Group Wizard... :

+ Availability Group name : SQLHA01 - Select Databases : Select DB01

+ Specify Replicas - Add Replica... - Server name : DC17 - Connect - Tick "Automatic Failover (Up to 2)" and "Synchronous Commit (Up to 3)"

- Readable Secondary : DC16 : Yes

+ Select data Synchronization : Choose Full : \\DC11\SQLShare - Next - Finish - Close

+ Shutdown

- DC17 : Check availability of DB01

+ Start - Microsoft SQL Server Management Studio - Server name : DC17 - Connect - DC17 (...) - Databases - DB01 === availability == OK

[vermashu]

Good Video. Have implemented the same in production environment with the help of this video but lack of information checks your patience. Let me clarify here.
1. This is active passive configuration.
3. Do remember not to install SQL as failover cluster. Install standalone SQL on both server having same Instance name.
4. Do remember to use a specific domain ID to run SQL Instance service on both server. (ID must be identical on both servers). Using NTService ID will fail joining SQL "Always On" Clustering.

Rest all is good. Good Luck.
Cheers..
AV

[JhonVillarrealDev]

What should be the size of the shared folder?

[radatann]

Is it active-active or active-passive configuration ? answer pls