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
标红的地方换成你的数据库名字【正式数据建议先备份后操作,避免数据丢失】
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
标红的地方换成你的数据库名字【正式数据建议先备份后操作,避免数据丢失】