sql 清除日志空间

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

USE DBCenter GO SELECT file_id, name FROM sys.database_files;  查找日志名称     USE DBCenter ; GO ALTER DATABASE DBCenter SET RECOVERY SIMPLE;--设置简单恢复模式 GO DBCC SHRINKFILE ('B2BCenter_log',0, TRUNCATEONLY) GO ALTER DATABASE DBCenter SET RECOVERY FULL;--恢复为原模式 GO                                                 清空日志