select log_reuse_wait_desc from sys.databases where name=tfs_CARDLANWEB  backup log tfs_CARDLANWEB to disk ...
select log_reuse_wait_desc from sys.databases where name='tfs_CARDLANWEB'
backup log tfs_CARDLANWEB to disk='D:\dbbackup\2014-08-24-2.log'
GO
DBCC SHRINKFILE (N'tfs_CARDLANWEB_log' , 1024, TRUNCATEONLY)
GO
--提示错误就重复操作
SELECT name ,size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0 AS AvailableSpaceInMB FROM sys.database_files;
原标题:SQLSERVER 2012 收缩日志
关键词:sql
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。