• FNS (10/20/2008)


    No, you cannot shrink the tlog on a mirrored database without breaking the mirror first.

    Given that your log is 50Gb vs data at 2Gb you're going to need to bite the bullet and turn off mirroring for a moment while you sort this out. Something is clearly amis here and you're going to need to get at things to figure out what which means turning off the mirror. The only job you should need to keep the tlog a sensible size is a regular tlog backup (via maint wizard if necessary). I'd also check this t-log backup actually working (ie you're getting a nice .trn file and it can be restored to a test system) and it is running regularly enough for the number of transactions that are being pumped through the database.

    I have scedule transaction log back every weekend. nut still no use. Trans log file is growing day by day.