02 2008 档案

摘要:日志的逻辑文件名是DBNAME_LOG,数据库DBNAME: USE DBNAME BACKUP LOG DBNAME WITH NO_LOG --截断事务日志 GOOPTION 1:DBCC SHRINKFILE(DBNAME_LOG,10) --收缩事务日志 GO OPTION 2:企业管理器--右键你要压缩的数据库--所有任务--收缩数据库--收缩文件--选择日志文件--在收缩方式里选择收缩... 阅读全文
posted @ 2008-02-22 10:12 Rickie 阅读(1325) 评论(0) 推荐(0) 编辑
摘要:A couple of strange warnings in the Security event log always occur when then transaction fails:Log 1:Event Type:Failure AuditEvent Source:SecurityEvent Category:Account Logon Event ID:680Date:2008-2-... 阅读全文
posted @ 2008-02-20 11:01 Rickie 阅读(927) 评论(0) 推荐(0) 编辑
摘要:The following SQL statement is used to reconfigure the SQL SERVER advanced settings, such as max text repl size. sp_configure 'max text repl size', 2147483647GORECONFIGURE;You can also configure this ... 阅读全文
posted @ 2008-02-02 13:58 Rickie 阅读(693) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示