USE[master]
GO
ALTER DATABASE ecology SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE ecology SET RECOVERY SIMPLE
GO
USE ecology
GO
DBCC SHRINKFILE (N'ecology_log' , 1, TRUNCATEONLY)
GO
USE[master]
GO
ALTER DATABASE ecology SET RECOVERY FULL WITH NO_WAIT
GO
--还原为完全模式
ALTER DATABASE ecology SET RECOVERY FULL
GO
GO
ALTER DATABASE ecology SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE ecology SET RECOVERY SIMPLE
GO
USE ecology
GO
DBCC SHRINKFILE (N'ecology_log' , 1, TRUNCATEONLY)
GO
USE[master]
GO
ALTER DATABASE ecology SET RECOVERY FULL WITH NO_WAIT
GO
--还原为完全模式
ALTER DATABASE ecology SET RECOVERY FULL
GO