2010/5/12

Windows SharePoint Services 3.0 資料庫檔案位置變更

1. 安裝 SQL Server Management Studio Express
2. 以Windows 驗證連線至 \\.\pipe\mssql$microsoft##ssee\sql\query
3. iisreset /stop ,停止網際網路服務
4. 停止所有 Windows SharePoint Services
Windows SharePoint Services Search
Windows SharePoint Services Timer
Windows SharePoint Services Tracing
5. SQL Server Management Studio Express,管理\活動監視器,確認無連線。
6. 卸離資料庫
SharePoint_AdminContent_a35a7822-e626-464d-a418-1ca30ae4b0c9
SharePoint_Config_248cc14f-d07a-4548-8de3-e9e81cf1a257
WSS_Content
WSS_Content_3e57240527f045e8bd5ddcebab319f36
WSS_Search_NTTP3S20
7. 資料庫檔案移至新位置。
自:C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data
至:D:\SQL\DATA\SSEE
8. 附加移至新位置資料庫檔案
SharePoint_AdminContent_a35a7822-e626-464d-a418-1ca30ae4b0c9
SharePoint_Config_248cc14f-d07a-4548-8de3-e9e81cf1a257
WSS_Content
WSS_Content_3e57240527f045e8bd5ddcebab319f36
WSS_Search_NTTP3S20
9. 啟動所有 Windows SharePoint Services
Windows SharePoint Services Search
Windows SharePoint Services Timer
Windows SharePoint Services Tracing
10.iisreset /start,啟動網際網路服務。
11.SQL Server Management Studio Express,管理\活動監視器,查看連線。
12.確認 SharePoint 小組網站運作正常。


Ref.
1.將 Windows Internal Databases 移至不同的磁碟機 (Windows SharePoint Services 3.0)

2.SQL Server Embedded Edition(SSEE) Tips