4

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"

1 Answer 1

5

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.

5
  • 2
    In addition, a cluster uses shared storage, so how would a failover help? Commented Oct 31, 2015 at 0:01
  • @Aaron it might help because failover causes SQL Server to restart.
    – Shanky
    Commented Oct 31, 2015 at 10:22
  • @shanky but the database files haven't moved - they're still the same size and they're still on the same full disks. Maybe that would help if tempdb was part of the problem and everything was all on one volume, but even in that hopefully unlikely scenario, that's a very temporary "fix." Commented Oct 31, 2015 at 12:57
  • @Aaron I was saying that when failover happens and if problem is due to transaction log full, then in that case tempdb is cleared and this might actually solve the issue when SQL Server comes online. Of course agree with you this is not a solution.
    – Shanky
    Commented Oct 31, 2015 at 14:09
  • @Shanky if it's the tempdb transaction log, and that's the only problem, maybe. The OP didn't say it was tempdb. Failover won't help a scenario where any other database's transaction log was full. Commented Oct 31, 2015 at 16:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.