Forum Replies Created

Viewing post 1 (of 1 total)

  • 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...

Viewing post 1 (of 1 total)