• Lynn Pettis (3/15/2013)


    I personally never tried shrinking the log of a mirrored database. If you can, perhaps you could set this up on a test server and see what happens.

    I'd be interested in knowing.

    After taking full and log backup, I see 99% free space on log file, but when I try to shink it, it's not working. I thought it should truncate the inactive logs after logbackup\shrink are done. I am not sure since mirroring is in place, it might not allowing this? Your thought.

    SueTons.

    Regards,
    SQLisAwe5oMe.