In general, the file extensions for our SQL Data Files are .mdf, .ndf and .ldf.
But, a different file extension also work with SQL Server.
This article helps in finding a way to rename the file extensions.
Rule “Network binding order” generated a warning.
The domain network is not the first bound network. This will cause domain operations to run slowly and can cause timeouts that result in failures. Use the Windows network advanced configuration to change the binding order.
--connect secondary replica select r.replica_server_name, r.endpoint_url, rs.connected_state_desc, rs.last_connect_error_description, rs.last_connect_error_number, rs.last_connect_error_timestamp from sys.dm_hadr_availability_replica_states rs join sys.availability_replicas r on rs.replica_id=r.replica_id where rs.is_local=1
--connect primary replica ALTER AVAILABILITY GROUP [AG01] MODIFY REPLICA ON 'TREDSHOST07' WITH (ENDPOINT_URL = 'TCP://172.16.35.10:5022') GO ALTER AVAILABILITY GROUP [AG01] MODIFY REPLICA ON 'TREDSHOST08' WITH (ENDPOINT_URL = 'TCP://172.16.35.11:5022') GO