SQL 收缩日志

USE [master]
ALTER DATABASE RcBalance SET RECOVERY SIMPLE WITH NO_WAIT
ALTER DATABASE RcBalance SET RECOVERY SIMPLE;

USE RcBalance
SELECT * from sys.database_files;

DBCC SHRINKFILE(N'Balance_Log' , 11, TRUNCATEONLY);
USE [master]
ALTER DATABASE RcBalance SET RECOVERY FULL WITH NO_WAIT
ALTER DATABASE RcBalance SET RECOVERY FULL;