USE master
GO
ALTER DATABASE 库名 SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE 库名 SET RECOVERY SIMPLE
GO
USE 库名
GO
DBCC SHRINKFILE (N'库名_Log' , 2, TRUNCATEONLY)
USE master
GO
ALTER DATABASE 库名 SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE 库名 SET RECOVERY SIMPLE
GO
USE 库名
GO
DBCC SHRINKFILE (N'库名_Log' , 2, TRUNCATEONLY)
转载于:https://www.cnblogs.com/DONET-LC/p/6392638.html