收缩数据库日志文件
USE[master]
GO
ALTER DATABASE SanWow SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE SanWow SET RECOVERY SIMPLE --简单模式
GO
USE SanWow
GO
DBCC SHRINKFILE (N'SanWow_log' , 11, TRUNCATEONLY)
GO
USE[master]
GO
ALTER DATABASE SanWow SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE SanWow SET RECOVERY FULL --还原为完全模式
GO
转载于:https://www.cnblogs.com/tianxiang2046/p/5211979.html
新人创作打卡挑战赛发博客就能抽奖!定制产品红包拿不停!总结
- 上一篇: Linux之grep命令详解
- 下一篇: Mysql索引介绍及常见索引的区别