✔ Windows cluster at-least 2 nodes.(Same domain)
✔ At-least ONE non-cluster instance on each node.
✔ Instances must be running with domain account.
✔ Required for databases
* DB must be in FULL recovery model.
* Full backup must be taken before configuring
* Check that service broker must be enabled on DB (By default its enabled)
✔ One shared folder in primary replica. (In Primary)
* R/W permission to primary replica.
* R permission to secondary replica.
✔ Always on feature must be enabled on all instances.
✔ SQL Server enterprise Edition (Standard Edition - 2016)
✔ If O/S is windows 2008 server then hotfix KB2694036 must be applied on each node.
✔ Database files must be in one folder and same path should be there in Other replicas.
✔ You need to configure between one and four secondary replicas, with any combination of Synchronous (Maximum of two) and Asynchronous Mirroring
(Your primary replica is available for read and write connectivity, while your secondary replicas can be configured for read-only access)
No comments:
Post a Comment