Learn how to shrink a data or log file in SQL Server by using SQL Server Management Studio or Transact-SQL. Shrinking data files recovers space by moving pages of data from the end of the file to ...

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.

Topic: Shrink SQL Server Transaction Log for all Databases. Generate T-SQL commands to shrink all SQL Server user database log files or shrink a single database log file back to the original size or ...

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.