Post reply

Unable to reclaim transaction log space after removing replication

  • November 5, 2009 at 6:37 pm

    #213547

    Hello!

    I have removed replication on the server but log space is not being reclaimed because some of the transactions are still marked for replication:

    select log_reuse_wait_desc,* from sys.databases --shows REPLICATION

    Following command doesn't work because database is no longer marked for replication

    EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset = 1

    Database is in SIMPLE recovery mode. Any ideas how I can remove transactions marked for replication from the log?

    Thanks,

    Igor

  • November 5, 2009 at 8:09 pm

    #1075683

    Try this.

    Create a new transactional publication. Run sp_repldone. Drop the publication

    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

  • November 5, 2009 at 11:46 pm

    #1075728

    Thank you so much, Gail! It worked like a charm.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply