Sql server shrink ldf files

If "full recovery", have you created full backup lately? Selecting this option may affect performance. Arvo How do I see the recovery model I use? Show 2 more comments. Active Oldest Votes. Thank you in advance — XsiSec. You will have enough storage on your null device, believe me ;- — CeOnSql. Ok now the title "Can't Shrink a. LDF file" does not describe your whole problem? If you want to know something about earlier backups: ask the administrator or former administrator of this server.

If this person is not available: develop your ouwn backup strategies and don't care too much about older. Sign up or log in Sign up using Google.

Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Submit and view feedback for This product This page. View all page feedback. Rather than rewrite what has already been said quite well. Please checkout the following link. It will tell you how you got where you are, how to fix it and how to avoid it in the future.

Adding this link to the Microsoft instructions on how to modify the recovery model for anyone else having my problem that finds this post in the future. This sacrifices point-in-time recovery prior to the time of the switch. You also need to address the issue of why the situation occurred in the first place.

If you don't, you could find yourself right back where you started from. An excellent work on SQL Server backup and restore can be found here. It clearly lays out how SQL Server backup and restore works and guides you through setting up a sensible strategy to prevent it from happening altogether. See all products at a glance. DIY print management for everyone. Powerful print management for printers and MFDs.

Print management for small businesses in the cloud. Complete cloud-native print management for business. A free Google Cloud Print alternative. The power of digital documents — on paper.