sql server shrink database with transact sql

USE userDBname;
GO
ALTER DATABASE userDBname
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE (userDBname_log, 0);--0 = tamamen boşalt
GO

ALTER DATABASE userDBname
SET RECOVERY FULL;
GO