--数据库名称为 [KLWebsite_Manager]
USE [KLWebsite_Manager]
GO
ALTER DATABASE [KLWebsite_Manager] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [KLWebsite_Manager] SET RECOVERY SIMPLE --将指定数据库设置为简单模式
GO
USE [KLWebsite_Manager]
GO
DBCC SHRINKFILE (2 , 11, TRUNCATEONLY)
GO
USE [KLWebsite_Manager]
GO
ALTER DATABASE [KLWebsite_Manager]SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE [KLWebsite_Manager]SET RECOVERY FULL
GO
USE [KLWebsite_Manager]
GO
ALTER DATABASE [KLWebsite_Manager] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [KLWebsite_Manager] SET RECOVERY SIMPLE --将指定数据库设置为简单模式
GO
USE [KLWebsite_Manager]
GO
DBCC SHRINKFILE (2 , 11, TRUNCATEONLY)
GO
USE [KLWebsite_Manager]
GO
ALTER DATABASE [KLWebsite_Manager]SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE [KLWebsite_Manager]SET RECOVERY FULL
GO