database mirroring RRS feed

  • Question

  • what are reasons to  the transaction log gets full in DB mirroring?
    Tuesday, June 12, 2012 3:57 AM


  • Hi,

    The transaction log on the principal cannot be truncated or wrap around until the transactions have been written to the mirror copy. Therefore the transaction log can continue to grow as the existing transactions in the log cannot be cleared.

    What does the following query return?

    select name,log_reuse_wait_desc from sys.databases

    Sean Massey | Consultant, iUNITE

    Feel free to contact me through My Blog, Twitter or Hire Me.
    Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

    • Proposed as answer by Maggie Luo Wednesday, June 13, 2012 6:52 AM
    • Marked as answer by Maggie Luo Tuesday, June 19, 2012 8:20 AM
    Tuesday, June 12, 2012 4:11 AM