Warning: Undefined array key "HTTP_REFERER" in /www/wwwroot/prod/www.enjoyasp.net/wp-content/plugins/google-highlight/google-hilite.php on line 58
–数据库日志文件增长的很快,每次手工收缩不能及时,用下面的方法建立一job可以定时运行
USE brm_lvjian
–设置数据库恢复模式为简单
ALTER DATABASE BRM_LVJIAN
SET RECOVERY SIMPLE
–收缩日志到1M
DBCC SHRINKFILE (‘BRM_LVJIAN_Log’, 1);
–设置数据库恢复模式为完整
ALTER DATABASE BRM_LVJIAN
SET RECOVERY FULL