You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Welcome to the CAREWare FAQ Page
announcement close button
Home > Troubleshooting and SQL Queries > Troubleshooting Common Issues > Transaction log fails to shrink
Transaction log fails to shrink
print icon
Kevin Ricciardo
Feb 05, 2025
views icon 218

If transaction log fails to shrink.

 

  1. Make a full backup

  2. Switch recovery mode to simple

  3. Shrink the transaction log with truncate

  4. Switch recovery mode to full

  5. Perform another full backup

Feedback
0 out of 0 found this helpful

Attachments

Transaction_log_fails_to_shrink.pdf
close button
scroll to top icon