1. 先找到Log文件名
USE [DBName]
GOSELECT file_id, name FROM sys.database_files;
GO
2. 清除log
USE master
GO
ALTER DATABASE [DBName] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [DBName] SET RECOVERY SIMPLE --简单模式
GO
USE [DBName]
GO
DBCC SHRINKFILE (N'DBName_log' , 11, TRUNCATEONLY)
GO
USE master
GO
ALTER DATABASE [DBName] SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE [DBName] SET RECOVERY FULL --还原为完全模式
GO