AlwaysOn Configuration

Hey ! Here I'm defining the step by step Always On configuration, Follow few basic steps and configure your HA+DR plans easily, hope it will help you more.

-----------------------------------------------------------------------------------------------------------------

Step-1 : Check instance is running on domain or not(for both node1 and node2).Check TCPIP is enabled or not (By default it is enabled).

Windows + R : sqlservermanager11.msc --define your version

Step-2 : Enable AO Availability Group(for both node1 and node2) by Right-click on SQL Server service --> Propeties --> AlwasysOn High Availability Groups after that restart service, Later restart both nodes.

Step-3 : Now check which is the active node in windows cluster by command cluadmin.msc .

Step-4 : After that connect both instances in SSMS and create some database on Primary node

Note : Here your database data path(Drive) should be same , Create a folder for backup (its location should be same for both instance), After this take a full backup of this database.

Step-5 : R.C. on Always On High Availability-->Availability Groups-->New Availability Group Wizard, Set Availability Group Name Like AOGRP1 (Check boxes are optional) then click next..

Step-6 : 

✓ Select databases : to configuring AO (You can see status as : Meets prerequisites) then click next..

✓ Specify Replicas : click on add replica button and connect secondary instance.

✓ Select both check boxes (Automatic failover option) also select readable secondary.

✓ Backup Preferences(Choose prefer secondary option: we can schedule backup on secondary replica)and then next..

✓ Select Data Synchronization : Automatic seeding (Ask the wizard to automatic restore) and click next..

✓ Validation : Click on next..

✓ Summary : Click on Finish (You can save script file).

✓ Now you can see database will be restoring on secondary instance.

✓ You can see database status will be on Synchronization Status (For both instances : No need to create snap-shot).

Step-7 : You can check AO Configuration list by going on Always On High Availability option.

Step-8 : Create a table and insert data on Primary instance : You will get the same on Secondary instance (It will be done by AO performance).