压缩数据库日志

--清空日志

dump transaction SharePoint_Config with no_log

--压缩数据库日志
backup log SharePoint_Config   with no_log
--压缩数据库文件

DBCC   SHRINKDATABASE(SharePoint_Config )  
--设置自动压缩

EXEC   sp_dboption   'SharePoint_Config',   'autoshrink',   'TRUE'

-------------------------------------

 

当sharepoint 数据库 wss_content 的日志文件超过 2g的时候就会报一些连接不上数据库的问题

这时候我们需要收缩日志，并且重启 Windows Sharepoint Timer Service 服务。

 

 

 

The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database SharePoint_Config on SDS439-003.  Check the database connection information and make sure that the database server is running..

 

Distributed Transaction Coordinator (MSDTC)
Windows SharePoint services Administration
Windows SharePoint Services Search
Windows SharePoint Services Timer
Windows SharePoint Services Tracing
Office SharePoint Server Search(2008/1/23日追加)

我并没有使用MSDTC，所以此项与我无关，但是其中的Windows SharePoint services Administration和Windows SharePoint Services Tracing分别使用的是Local system account和Local service account，将他们换成专用的本地管理员账户