MSSQL 事务日志满解决方法

USE PushTermDB
SELECT name ,size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0 AS AvailableSpaceInMB
FROM sys.database_files;

 
DBCC SQLPERF(LOGSPACE)

 
USE [master]
 SELECT [name] ,[database_id] ,[log_reuse_wait] ,[log_reuse_wait_desc] FROM [sys].[databases]
 

DBCC SHRINKFILE (N'PushTermDB_log' ,1024, TRUNCATEONLY)

select log_reuse_wait_desc from sys.databases where name='PushTermDB'

USE [dbname]
GO
backup log dbname to disk='D:\dbbackup\2014-08-24-2.log'
GO
DBCC SHRINKFILE (N'a23648263485_Log' , 700, TRUNCATEONLY)
GO