| TERMS |
|
This document and what comes with it are
provided as-is with blunt warning: Use at your own risk,
buyer beware. You break your system; you own the resolution
as well. We have no liability for what you do, or can't
do, or fail to do with this information. Your entire protection
is to start over again with a protected backup, or from
protected system. If you don't want to accept this idea,
please don't use this document.
|
- While still in Microsoft SQL Server Management Studio, in Object Explorer , expand ServerName\SHAREPOINT (SQL Server 9.0.1399 - DomainName\administrator), where DomainName is the name of your Windows SBS domain.
- Right-click Databases, and then click Attach (Figure 1).
Figure 1 - Attach a database.
- On the Attach Databases page (Figure 2), click Add.
Figure 2 - Attach Databases
- Browse to %SystemDrive%\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\data, select STS_ServerName_1.mdf and then click OK.
Figure 3 - Attach the Sharepoint database.
Note: If you installed the Sharepoint MSDE instance on another drive as described in 'Planning and installing your SBS 2003 Server', you will need to attach the databases from the partition the Sharepoint MSDE instance was originally installed. As you can see in figure 3 my databases are on partition D:.
- On the Attach Databases page (Figure 4), click OK. The action (Firgure 5) finishes and Object Explorer in Microsoft SQL Server Management Studio (Figure 6) appears.
Figure 4 - Attach databases.
Figure 5 - In progress.
Figure 6 - We are back in SQL Server Management studio and there is our Sharepoint database listed.
- Repeat step 2 through 5 to attach the STS_Config.mdf database file. After you have repeated steps 2 through 5 for the Sharepoint Services Configuration database the end result you look like figure 7.
Figure 7 - All Sharepoint databases are attached in SQL Server Management Studio.
- Restart the Windows SharePoint Timer Service by clicking Start (Figure 8), pointing to Administrative Tools, and then clicking Services. Right-click SharePoint Timer Service, and then click Properties. On the General tab, select Automatic for the Startup Type (Figure 9). Click Start to start the service, and then click OK to close the SharePoint Timer Service Properties dialog box.
Figure 8 - Restart the Windows SharePoint Timer Service.
Figure 9 - Set the Windows Sharepoint Timer Service to start automatic.
- Close Services.
- Restart http://companyweb by clicking Start and then clicking Server Management (Figure 10). In the Server Management console, double-click Advanced Management, double-click Internet Information Services, double-click ServerName (local computer), and then double-click Websites. Right-click companyweb, and then click Start.
Figure 10 - Restart the companyweb.
|