SQLserver日志文件太大快速清理方法
(2015-01-27 11:22:55)| 标签: it | 分类: IT | 
USE DATABASENAME GO
 
ALTER DATABASE DATABASENAME SET RECOVERY SIMPLE
 
DBCC SHRINKFILE (DATABASENAME_Log, 1)
 
ALTER DATABASE DATABASENAME SET RECOVERY FULL

 加载中…
加载中…