Would SQL in a cluster failover when transaction log for database is full?

Posted on

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::

  1. due to ‘log_backup’
  2. due to ‘availability replica’
  3. active_transaction
  4. ‘replication’
  5. ‘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.

Leave a Reply

Your email address will not be published.