SQL Server - cannot DBCC SHRINKFILE on a busy Production Server


I try to shrink a log file (DBCC SHRINKFILE)of a production server but failure

Since the DB is in production, the log file cannot be truncated (it keeps adding new one).

After reference the below link, I have turned my Production DB to Simple Recovery Mode temporary and is able to shrink the log files (delete all log record and prevent new one to write into the log file).  Then I switch back the to Full Recovery Mode.

Reference:

Comments

Popular Posts