How to Shrink Database Transaction Log

1. Connect to Database use Microsoft SQL Server Management Studio
2. Start a New Query
3. Copy and Paste the following SQL Script into the New Query
4. Shrink Database Log SQLScript

   DECLARE @dbName VARCHAR(50) DECLARE @logName VARCHAR(100) SELECT @dbName = DB_NAME() SELECT @logName = name FROM SYS.database_files WHERE type = 1 EXECUTE('ALTER DATABASE[' + @dbName + '] SET RECOVERY SIMPLE') DBCC SHRINKFILE (@logName, 1); EXECUTE('ALTER DATABASE[' + @dbName + '] SET RECOVERY FULL') 

   
   
   
   

4. Execute the Query

Please refer How to Connect to Database use Microsoft SQL Server Management Studio