Home Forums SQL Server 2008 SQL Server 2008 High Availability Question regarding Log issues with Mirroring database. RE: Question regarding Log issues with Mirroring database.

  • March 15, 2013 at 4:41 pm

    #1597762

    GilaMonster (3/15/2013)

    Exactly what it says, all logical log files are in use, so there are no empty ones. No empty VLFs = no shrink.

    Check log_reuse_wait_desc in sys.databases for why the log is not being reused.

    Ok....got it, finally it allowed me to shrink, I gues a lot of activities were happening behind. Anyway, thanks for all of your input.

    Regards,

    SueTons.

    Regards,
    SQLisAwe5oMe.