• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2336
  • Last Modified:

SQL 2008 R2 Truncate Log file in a mirrored DB

Hi All,

  I have setup my SQL 2008 R2 DB mirroring for 1 DB, the size for the DB is 800 GB, my log file is growing very fast and I need to shrink it, I ran the shrink command but the size is still very large, what is the best way to handle the log file and to clear it in a regular bases, Im using DB mirroring and I need to know the best way to clear the log and to keep my mirroring running,

  • 2
2 Solutions

Head over to here, recent solution regarding the log management.


But, you may need to disconnect your mirror for a time? Then reconnect?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now