(1)方法一
BACKUP LOG TESTStagingDB WITH TRUNCATE_ONLY
GO
USE [TESTStagingDB]
GO
DBCC SHRINKFILE (N'TESTStaging_log' , 0, TRUNCATEONLY)
GO
---------------------------------------------------------------------------------------
BACKUP LOG TESTDWDB WITH TRUNCATE_ONLY
GO
USE [TESTWDB]
GO
DBCC SHRINKFILE (N'TESTDWDB_log' , 0, TRUNCATEONLY)
GO
(2)方法二
USE [tempdb]
GO
DBCC SHRINKDATABASE(N'tempdb' )
GO
...................................................................................
DBCC SHRINKDATABASE(N'TESTDB' )