How to manually failover SQL Server Availability Group in Linux CentOS 7
How to manually failover SQL Server Availability Group in Linux CentOS 7 explains all the steps you need to perform to failover Availability Group in SQL Server when installed on Linux.
You will learn below items in this video
1-- Check Constraints
a) Location Constraint
b) Ordering Constraint
2 -- Failover Availability Group to Specific Node
3 -- Remove Location Constraint to remove preferred node settings.
Scripts used in this video:
# Check current owner node of SQL Sever AG
pcs status
# Check Constraints
pcs constraint list --full
# Move SQL Server Availability Group resources from One node to another
pcs resource move TBSLinuxRG-master TBSLinuxNode2 --master
# Remove location constraint for successful Failover
pcs constraint remove cli-prefer-TBSLinuxRG-master
How to manually failover SQL Server Availability Group in Linux CentOS 7
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.