Record

@DB = '資料庫名'

腳本開始

--------------------------------------

DECLARE @Sql NVARCHAR(4000)
DECLARE @DB sysname
SET @DB = 'EP_01'
SET @Sql = '
DUMP TRANSACTION ' + @DB + ' WITH NO_LOG
BACKUP LOG ' + @DB + ' WITH NO_LOG
DBCC SHRINKDATABASE(' + @DB + ')'

EXEC(@Sql)

---------------------------------------