ALTER DATABASE DevAssistant
SET RECOVERY SIMPLE;--设置简单恢复模式
GO
DBCC SHRINKFILE (DevAssistant_Log, 1);
GO
ALTER DATABASE DevAssistant
SET RECOVERY FULL;--恢复为原模式
GO
ALTER DATABASE DevAssistant
SET RECOVERY SIMPLE;--设置简单恢复模式
GO
DBCC SHRINKFILE (DevAssistant_Log, 1);
GO
ALTER DATABASE DevAssistant
SET RECOVERY FULL;--恢复为原模式
GO
转载于:https://www.cnblogs.com/pgboy/p/5496572.html