各位好,
我是 SQL Server 2005 / SharePoint 3.0 管理中心.
我用 本機的 SQL Server 2005 / SQL Server Management Studio Express 無法顯示本的 SQL 資料庫(為空白), 使用網路連結也不行.
利用檔案開啟 WSS_Content.mdf , 錯誤顯示: 無法開啟檔案, 因為其他處理序正在使用它. 請關閉可能使用這個檔案的所有應用程式, 然後再試一次.
請問該如何處理?
目前我的 SharePoint 主機, 磁碟空間被佔滿了.
查察下是 SharePoint: C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\ SharePoint_Config_xxxxxx_log.LDF 和 WSS_Content_log.LDF 佔滿了磁碟空間.
但, 我使用 MS SQL SSMS, 卻無法登入此主機的SQL Server.
請問:
1. 如何登入 SharePoint的資料庫內?
2. 如何縮小此2個 Log的檔案大小??
謝謝.
Hello All,
My MS Products is SharePoint 3.0 Management Center with SQL Server 2005 (Express),
I try to used SQL Server Management Studio Express but can't show the local SQL Server, I don't know why?
Currently, the disk space on my SharePoint host is full.
Check that SharePoint: C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\ SharePoint_Config_xxxxxx_log.LDF and WSS_Content_log.LDF are taking up all disk space.
However, I use MS SQL SSMS, but I cannot connect to the SQL Server of this host.
I used the local SQL Server 2005 / SQL Server Management Studio Express and cannot display the local SQL database (it is blank), nor can I use a network connection.
Try to Opening WSS_Content.mdf with the file, error message: The file cannot be opened because it is in use by another process. Please close all applications that may use this file and try again.
What should I do?
Please help to tell me how to do about
1. How to connect to log in the SharePoint database?
2. How to reduce the file size of these two Logs??
Thanks in advance.
