Transaction Log issue


  • Dear All

    I have a database with SQL 2008 R2, running a database with SQL 2000 compatability.

    The database's recovery is set to simple.

    It is not been used for either replication or mirroeing

    According to sp_who2 there are no active connections to the database

    however a dbcc showtrans will show this

    Replicated Transaction Information:

    Oldest distributed LSN : (0:0:0)

    Oldest non-distributed LSN : (358765:944:1)

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    And the actual log file will not shrink. It has not gone up to over 200gb and growing. Any ideas on what to do ?

    Friday, November 15, 2013 5:01 PM


All replies