02 2008 档案
摘要:日志的逻辑文件名是DBNAME_LOG,数据库DBNAME: USE DBNAME BACKUP LOG DBNAME WITH NO_LOG --截断事务日志 GOOPTION 1:DBCC SHRINKFILE(DBNAME_LOG,10) --收缩事务日志 GO OPTION 2:企业管理器--右键你要压缩的数据库--所有任务--收缩数据库--收缩文件--选择日志文件--在收缩方式里选择收缩...
阅读全文
摘要: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-...
阅读全文
摘要: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 ...
阅读全文