Database Logs - Error On Shrinking
Search
Database Logs - Error On Shrinking
For reference, the MK Daytona database had replication enabled on it at some point. This meant that the database would wait to truncate logs (even in simple mode) until after a replication had been run. Since we don't actually use SQL server replication, the truncation would wait forever.
To resolve, execute some/all of the following TSQL (read comments, only certain chunks may be necessary): SELECT name, log_reuse_wait, log_reuse_wait_desc FROM sys.databases -- output should contain a row of name: 'ClubSpeedV8', log_reuse_wait: 0, log_reuse_wait_desc: 'NOTHING' -- if it does not, execute the following block: EXEC sp_removedbreplication [ClubSpeedV8] USE ClubSpeedV8; CHECKPOINT; -- then shrink the logfile as usual DBCC SHRINKFILE(ClubspeedV8_log); -- or right click the database -> tasks -> shrink -> files -> File type: 'Log' -> OK