USE [master] GO ALTER DATABASE IYX SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE IYX SET RECOVERY SIMPLE --简单模式 GO USE IYX GO DBCC SHRINKFILE (N'IYX_log' , 11, TRUNCATEONLY) GO USE [master] GO ALTER DATABASE IYX SET RECOVERY FULL WITH NO_WAIT GO ALTER DATABASE IYX SET RECOVERY FULL --还原为完全模式 GO
|
|
来自: 自信开朗 > 《sqlserver过程》