USE [master]
GO
--大容量模式
ALTER DATABASE [TEST] SET RECOVERY BULK_LOGGED WITH NO_WAIT
GO
--完整模式
ALTER DATABASE [TEST] SET RECOVERY FULL WITH NO_WAIT
GO
--简单模式
ALTER DATABASE [TEST] SET RECOVERY SIMPLE WITH NO_WAIT
GO
USE [master]
GO
--大容量模式
ALTER DATABASE [TEST] SET RECOVERY BULK_LOGGED WITH NO_WAIT
GO
--完整模式
ALTER DATABASE [TEST] SET RECOVERY FULL WITH NO_WAIT
GO
--简单模式
ALTER DATABASE [TEST] SET RECOVERY SIMPLE WITH NO_WAIT
GO