AlwaysOn Configuration Export - AG_PROD_01

SQLNODE01 | 2026-07-19 16:14:00
Source: www.powershelldba.de | sqmSQLTool v1.9.26.1
Illustrative example — this lab instance has no Always On Availability Group configured. Values below are representative, not measured output.
Replica Configuration
ReplicaAvailability ModeFailover ModeBackup%ReadableSecondary
SQLNODE01 (Primary)SYNCHRONOUS_COMMITAUTOMATIC0NO
SQLNODE02SYNCHRONOUS_COMMITAUTOMATIC100READ_ONLY
Listener
NameAG-LISTENER01
IP Address10.0.1.50
Port1433
Subnet Mask255.255.255.0
Databases in Availability Group
DatabaseSynchronization StateFailover Readiness
AG_TestDBSYNCHRONIZEDReady
sqmSQLTool  |  dtcSoftware / Uwe Janke  |  www.powershelldba.de   –   2026-07-19 16:14:00