Question :
I have a Microsoft SQL Cluster with one instance. If one of the databases is full, would SQL in a cluster failover when transaction log for database is full?
If it depends on the reason the transaction log is full please refer to following::
- due to ‘log_backup’
- due to ‘availability replica’
- active_transaction
- ‘replication’
- ‘CHECKPOINT”
Answer :
No, it shouldn’t because that is not a server level event that the cluster would be aware of when it happens.
I seem to recall coming across an article that referenced specific events that could cause a failover but can’t find it right now.