sqlserver bak还原时提示文件过大，系统盘符空间较小（数据库日志清理）

USE [master]

GO

ALTER DATABASE QTHQ SET RECOVERY SIMPLE WITH NO_WAIT

GO

ALTER DATABASE QTHQ SET RECOVERY SIMPLE

GO

USE QTHQ

GO

DBCC SHRINKFILE (N'QTHQ_log' , 11, TRUNCATEONLY)

 

GO