Simplest way to shrink transaction log files on a mirrored production database
- by MGOwen
What's the simplest way to shrink transaction log file on a mirrored production database?
I have to, as my disk space is running out.
I will make a full database backup before I do this, so I don't need to keep anything from the transaction log (right? I have daily full database backup, probably never need point-in-time restore, though I'll keep the option open if I can - that's all the .ldf is really for, correct?).
(Hope this isn't an exact duplicate, I read a lot of questions but couldn't find this exact scenario elsewhere).