Transaction log fails to shrink

Kevin Ricciardo

Feb 05, 2025

1261

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

Feedback

0 out of 0 found this helpful

Need additional information

Hard to understand

Inaccurate/irrelevant content

Missing/broken link

Attachments

Transaction_log_fails_to_shrink.pdf

jProg is a registered trademark of Jeff Murray's Programming Shop, Inc. All other products mentioned are registered trademarks or trademarks of their respective companies. Questions or problems regarding this web site should be directed to [email protected]. Copyright (c) 1998-2023 Jeff Murray's Programming Shop, Inc. (jProg), all rights reserved. jProg provides no warranty on accuracy, quality, reliability, or fitness of purpose for advice or other content provided on this website or for content provided by others on sites linked here.