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.

My allocated SQL Server space is 400MB; however, the DB regular goes beyond that (650MB most recently) and I need to connect to the server using Studio and do a manual shrink on the database.