Home Forums SQL Server 2005 Backups log_reuse_wait_desc = replication but there's no replication RE: log_reuse_wait_desc = replication but there's no replication

  • Thank you, thank you, thank you! Here was my command for our MSDB log file going out of control. After determining that our Simple recovery model database was acting like a full rcovery db:

    SELECT name, log_reuse_wait_desc FROM sys.databases

    log_reuse_wait_desc = Replication

    I forced removal of the replication (must have been caused during a restore at some point).

    EXEC sp_removedbreplication msdb

    Reran the following:

    SELECT name, log_reuse_wait_desc FROM sys.databases

    Forced to Simple Recovery (just to make sure):

    ALTER DATABASE msdb SET RECOVERY SIMPLE

    Ran standard shrink commands (found all over google or our favorite search engine 😉 )

    backup log msdb with truncate_only

    dbcc shrinkfile(MSDBLog)

    Chicka chicka boom boom...now there's enough room!