locked
database mirrorig RRS feed

  • Question

  • Hi,

    I have  configured the db mirroring, the transaction log reached to 99% , why and how to resolve this


    sharath

    Saturday, June 23, 2012 4:33 AM

Answers

  • Check for log backups.You should be running log backups without fail.

    You should constantly monitor the Send Queue and Redo queue for mirroring sync status.

    Thank you,


    Anup | Database Consultant

    Blog: www.sqlsailor.com Twitter: Follow me !

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Marked as answer by amber zhang Friday, June 29, 2012 9:42 AM
    Tuesday, June 26, 2012 6:31 PM

All replies

  • My wild guess would be that your Transaction Log Backups are not running...

    But to find out for sure please run "Select * from sys.databases". The query should give you a log_reuse_wait_desc, which tells why your log is not truncated.

    Saturday, June 23, 2012 9:27 PM
  • dbcc opentran may also helps you

    Monday, June 25, 2012 5:46 AM
  • if you see the database participle in database mirroring show synchonizing status instead synchonized .. it may cause this problem as well.

    If the database principle is not fully synchozing with mirroring server, log cant be clear as well

    Monday, June 25, 2012 11:01 AM
  • Check for log backups.You should be running log backups without fail.

    You should constantly monitor the Send Queue and Redo queue for mirroring sync status.

    Thank you,


    Anup | Database Consultant

    Blog: www.sqlsailor.com Twitter: Follow me !

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Marked as answer by amber zhang Friday, June 29, 2012 9:42 AM
    Tuesday, June 26, 2012 6:31 PM