--USE jshh;
--GO
--ALTER DATABASE jshh
--SET RECOVERY SIMPLE;
--GO
--DBCC SHRINKFILE (jshh_Log, 1);
--GO
--ALTER DATABASE jshh
--SET RECOVERY FULL;
--GO
USE master
GO
ALTER DATABASE jshh SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE jshh SET RECOVERY SIMPLE --简单模式
GO
USE jshh
GO
DBCC SHRINKFILE (N'jshh_Log' , 11, TRUNCATEONLY)
GO
USE master
ALTER DATABASE jshh SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE jshh SET RECOVERY FULL --还原为完全模式