Wednesday, September 8, 2010

SharePoint Foundation 2010 on SBS 2008 – Step 10

As noted in a previous blog post I think that step 10 in the Microsoft process of migrating to SharePoint Foundation 2010 on SBS 2008 is incorrect:

 

http://technet.microsoft.com/en-us/library/ff959273%28WS.10%29.aspx

 

So here’s what I think Step 10 should show (including pictures):

 

Step 10 - Connect the ShareWebDb database to SQL Server 2008 (CIAOPS versions)

 

The old WSS v3 database now needs to be attached to the new SQL Server for management. You will need to have the SQL Management Studio open (as an administrator) to complete these tasks.

 

Navigate to the Database folder for the SQLEXPRESS tree. Right mouse click on the Database folder in the SQL Server (in this case SQL Express 2008 R2 denoted as SQLEXPRESS at the top of the object explorer window) and select Attach.

 

image_2_781DEEC2

 

You will now see the Attach Database window like show below:

 

image_4_632C6C4F

 

Press the Add button.

 

image_6_632C6C4F

 

(in the screen shot above the database shown is called WSS_Content but in the standard SBS 2008 case it will be called ShareWebDb)

 

Navigate to the location of the old WSS v3 database. In the default case this will be c:\windows\sysmsi\ssee\MSSQL.2005\MSSQL\data and the database will be called sharewebdb. Select the database and press the OK button to continue.

 

image_8_632C6C4F

 

You should now see the database and log file listed in the lower window. Press the OK button to attach these databases.

 

image_10_632C6C4F

 

You should now see the word Executing appear in the lower left of the window. When complete you should be returned to the object explorer window where you should see the database now listed under the SQL Express databases folder.

 

image_12_1119BF08

 

From there you should be able to continue on with Step 11 of the standard Microsoft process.

 

I’ll detail some other things about this process soon.

 

This information can from? My SharePoint Operations Guide that I’d recommend if you are needing to this sort of stuff.