SQL Server Performance

Shrink Transaction log of Principal Database??

Discussion in 'ALL SQL SERVER QUESTIONS' started by Trev256b, May 28, 2013.

  1. Trev256b Member

    Can the transaction log of a principal database in a database mirror partnership be shrunk without breaking the mirroring?
  2. davidfarr Member

  3. ghemant Moderator

    Hi,
    Yes, you can shrink it, however it is not good practice. What you need to do is you need to create a Log Backup job and run it frequently to keep your log file in shape.
  4. Trev256b Member

    Hi Ghemant - OK at least we now know we can shrink the transaction log on the principle database in the mirror partnership safely without breaking the mirror. I am assuming shrinking is not best practice because maintaining the transaction log size by backing it is 'better'. Please let me know if this is not your view.
  5. ghemant Moderator

    Yes, I agree. Keep running log backup every few minutes to maintain log file size in good shape.

Share This Page