News
Keep the backups! Then in the SQL Management Studio shrink the log file sizes. They won't shrink by themselves. From then on, run regular SQL backups and the logs won't get big.
Using the Transact SQL ALTER DATABASE statement to shrink the transaction log file Open SQL Server Management Studio (SSMS) and click Query Analyzer to open the Query Analyzer window.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results