patternsqlMinor
Would SQL in a cluster failover when transaction log for database is full?
Viewed 0 times
fulllogsqldatabasewouldfailovertransactionwhenforcluster
Problem
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::
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"
Solution
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.
I seem to recall coming across an article that referenced specific events that could cause a failover but can't find it right now.
Context
StackExchange Database Administrators Q#119694, answer score: 5
Revisions (0)
No revisions yet.