/*查看狀態(tài)*/

USE [master]

select [name] ,[database_id] ,[log_reuse_wait] ,[log_reuse_wait_desc] from [sys].[databases]

where name = 'xxxDB';

/*查看庫正在執(zhí)行任務(wù)*/

select top 100  *

from sys.dm_exec_requests req 

CROSS APPLY sys.dm_exec_sql_text(req.[sql_handle]) pln

/*殺掉相關(guān)進程*/

KILL <session_id>