SQL Galaxy (11/18/2014)
Thank you for mention missed points(number), I have updated my documents.
No, they are still a very high level, you need to be looking a lot deeper into this. It will pay you to study Windows Server Failover Clusters and AlwaysOn Availability groups in a lot more detail. Start by reading my stairway series on this site, the first 3 levels are linked below
Also have a read through this
SQL Galaxy (11/18/2014)
Perry Whittle
What witness type do you intend to use for your Windows Server failover Cluster?It means FULL RECOVERY MODE. For data synchronize both database, but I am not sure.
No, it's nothing to do with the database recovery model, it's a fundamental part of the Windows Server Failover Cluster configuration and is nothing to do with SQL Server.
Read the above for more detail.
SQL Galaxy (11/18/2014)
I have one domain account for SQL service account for both nodes, there is no special privileges assigned just for service account.Does it require any special privileges for domain service accounts?
Yes, due to the way Service Principal Names work, if you want the SPN to be created successfully upon failover, all replicas in the AlwaysOn Availability group must use the same service account. This is because an SPN is registered against the user account, if the instances use different accounts the SPN will fail when the listener is passed to nodes where instances use a different service account.
The accounts require no special privileges, they are granted during installation.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉