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
May 20, 2024
views icon 143

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

close button
scroll to top icon