solution involves creating a T-SQL stored procedure in a SQL Server database called dbo.usp_ShrinkAllLogsExcludeSysDBS that will get a parameter for the database name. The parameter will default 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 ...