DB_PY_Product:数据库名称,以下替换
USE [master]
GO
ALTER DATABASE [DB_PY_Product] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [DB_PY_Product] SET RECOVERY SIMPLE --简单模式
GO
USE [DB_PY_Product]
GO
DBCC SHRINKFILE ('DB_PY_Product_log' , 11, TRUNCATEONLY)
GO
USE DB_PY_Product
GO
SELECT file_id, name FROM sys.database_files
GO
USE [master]
GO
ALTER DATABASE DB_PY_Product SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE DB_PY_Product SET RECOVERY FULL --还原为完全模式
GO