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

  • Perfect

    --- 1. Query

    SELECT name, log_reuse_wait_desc FROM sys.databases

    --- check if MyDatabaseName says

    --- log_reuse_wait_desc = Replication

    --- 2. Force removal of the replication.

    EXEC sp_removedbreplication MyDatabaseName

    --- 3. Check

    SELECT name, log_reuse_wait_desc FROM sys.databases

    --- check if MyDatabaseName says

    --- log_reuse_wait_desc = Nothing

    --- 4. Force your DB to Simple Recovery:

    ALTER DATABASE MyDatabaseName SET RECOVERY SIMPLE

    --- 5. Run db shrink command

    backup log MyDatabaseName with truncate_only

    dbcc shrinkfile(MyDatabaseNameLog)

    --- Perfect

    --- thanks again 🙂