How to shrink huge log files

Here is a short script to quickly shrink your log file if you DO NOT NEED to ever recover the database before the last full backup. Keep in mind that changing the Recovery Model to SIMPLE will break the log chain. You will need perform a backup of your database to start a new log chain and rebuild log-shipping. This solution should only be used if you know fully well the database you are applying it to.

Here’s a good link discussing the issue:
How to shrink the database transaction log

Views – 2074

Leave a Reply