use DBTest
DECLARE @LogFileLogicalName sysname
SELECT @LogFileLogicalName=name FROM sys.database_files where type=1
PRINT @LogFileLogicalName
DBCC SHRINKFILE(@LogFileLogicalName,1)
DECLARE @LogFileLogicalName sysname
SELECT @LogFileLogicalName=name FROM sys.database_files where type=1
PRINT @LogFileLogicalName
DBCC SHRINKFILE(@LogFileLogicalName,1)