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.

So I have a specific database that won't release and shrink its log files. The DB backups are happening successfully, but I still have 4GB of logfiles (and no, this DB does not generate 4GB of log ...

For instance, the logs in SQL Server Integration Services now show "the total number of rows sent in Data Flows." When using the Shrink Database option, users now get "enhanced warning messages ...

If you have worked with database maintenance plans in SQL Server 2005 or SQL Server 2008, then you are already familiar with what can be done in SSIS.