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"
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.

  • 2
    In addition, a cluster uses shared storage, so how would a failover help? – Aaron Bertrand Oct 31 '15 at 0:01
  • @Aaron it might help because failover causes SQL Server to restart. – Shanky Oct 31 '15 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." – Aaron Bertrand Oct 31 '15 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 Oct 31 '15 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. – Aaron Bertrand Oct 31 '15 at 16:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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