Home Forums SQL Server 2012 SQL 2012 - General truncate log RE: truncate log

  • October 20, 2014 at 2:20 am

    #1753421

    charipg (10/20/2014)

    db is in simple recovery model, log file is around 80GB,there is not much freespace to shrink file, trying to truncate but its not release the space.

    SELECT [name], recovery_model_desc, log_reuse_wait_desc FROM sys.databases;---it showing replication.

    so removed the replication sp_removedbreplication 'mydbname' and disabled replication also , but still 'log_reuse_wait_desc' is showing as 'replication'.

    Run CHECKPOINT, look at the log reuse wait again. What is it now?

    Do you have CDC running/configured against this database?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass