-- 设置简单日志,截断日志
ALTER DATABASE penma SET RECOVERY SIMPLE;
GO
-- 收缩数据库日志.
DBCC SHRINKFILE (penma_Log, 100);
GO
-- 设置完全日志
ALTER DATABASE penma SET RECOVERY FULL;
GO
-- 设置简单日志,截断日志
ALTER DATABASE penma SET RECOVERY SIMPLE;
GO
-- 收缩数据库日志.
DBCC SHRINKFILE (penma_Log, 100);
GO
-- 设置完全日志
ALTER DATABASE penma SET RECOVERY FULL;
GO