Declare @DataBaseName as nvarchar(50)
Declare @BackupPath as nvarchar(100)
Set @DataBaseName = 'DataBaseName'


-- ログの切捨て
BACKUP LOG @DataBaseName TO DISK = N'NUL'
DBCC SHRINKDATABASE(@DataBaseName)