"I could use a tranlog backup, and then roll it to 12:01am"
Do that. You can restore the last full backup, then apply log backups with NORECOVERY in the days or hours before the first of the month, then apply the last log backup with STOPAT and RECOVERY or STANDBY.
Or you could create a Database Snapshot at midnight on the first of the month. ...
Queries against read-only secondary replicas implicitly run in snapshot isolation regardless of the session isolation level or RCSI setting. This avoids blocking due to DML changes. Read-only queries still acquire schema stability locks, which will block DDL operations by redo threads and visa-versa.
SPID 129 blocks a session ID 45 ( i am sure this is not a ...
You can fail over to a readable secondary. The author is either wrong, or just using some confusing terminology. Reading the exact quote you included, I'd lean towards the former explanation. But I don't know all the context around that statement.
Here I have an AG - all replicas are configured to be readable when they are in the secondary role, and NODE2 ...
Read-only routing is per connection, not per batch or statement. Read-only intent is specified via the application connection string and the connection will be directed to a read-only replica (if possible) when the connection is established.
We have now resolved this issue, was caused by the AWS DNS suffixes it appends to the domains. This caused issues with our domain names.
Have changed this setting to append primary and connect specific DNS suffixes and I was able to see both networks when building the cluster.
I've seen that recurring error about joining the database when automatic seeding was used to initialize the secondary replicas. My solution has always been to disable automatic seeding once the secondary databases have all been created and synchronized:
ALTER AVAILABILITY GROUP YourAgName
MODIFY REPLICA ON 'YourReplicaName'
WITH (SEEDING_MODE = MANUAL);