May 20, 2024
143
If transaction log fails to shrink.
-
Make a full backup
-
Switch recovery mode to simple
-
Shrink the transaction log with truncate
-
Switch recovery mode to full
-
Perform another full backup