Use this query to check: SELECT name, recovery_model_desc, log_reuse_wait_desc FROM sys.databases; 1. NOTHING What It Means: No current reason blocking log reuse.