删除日志文件
USE [master]
GO
ALTER DATABASE SCADA_Other SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE SCADA_Other SET RECOVERY SIMPLE
GO
USE SCADA_Other
GO
DBCC SHRINKFILE (N'SCADA_Other_log' , 11, TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE SCADA_Other SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE SCADA_Other SET RECOVERY FULL