Home Forums SQL Server 7,2000 Administration DBCC LOGINFO has a status 2 that I can''t seem to get rid of RE: DBCC LOGINFO has a status 2 that I can''t seem to get rid of

  • What is DBCC OPENTRAN shows that there are no open transactions?

    DBCC LOGINFO shows 871 records in my case. The first 864 all have a status of 2.

    My log file is 40gb and I'll really like to knock it down.

    I've tried everything around shrinking, setting to SIMPLE then FULL recovery, doing FULL backups, numerous TLOGs, etc.

    I'm all ears about what to try next.

    Thanks in advance.

    Nick