Monday, November 8, 2010

Migration by the numbers – Step 10

Step 10 in a series of posts documenting the Microsoft SharePoint Foundation 2010 upgrade process on SBS 2008. This is based on the document:;;displayLang=en

Previous steps:

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 10 - Attach the ShareWebDb database to SQL Server 2008

Select Start | Control Panel | Programs and Features.



Locate the entry Microsoft SQL Server Management Studio Express. Select it and then click the Uninstall button at the top of the window.




Select Yes to continue.




Select Yes to continue.


(*Authors note – you will be installing a 2008 version of the SQL Management Studio which allows the support of SQL 2008 & 2005 databases)


Download Microsoft SQL Server 2008 Management Studio Express. The direct link is:


Install the download on the server.




(*Authors note – recommend you run the install as an administrator)




(*Authors note – Select Installation from menu on left and then New SQL Server stand-alone installation or add features to an existing installation on the right).



(*Authors note – select OK when available).




(*Authors note – select Install when available).




(*Authors note – select Next when available).



Select Perform a new installation of SQL Server 2008.


(*Authors note – select Next when available. You can select either option here I believe, however as this installation package is only the SQL Management Studio a new installation will only install that as we will see in a few screens).



(*Authors note – select Next when available).




(*Authors note – select I accept the license terms and then Next).




Select Management Tools – Basic.


(*Authors note – then Next. If you chose to add features in a previous screen this option is hidden as it is the only option to add to an existing instance).




(*Authors note – select Next when available).




(*Authors note – leave all options unchecked and select Next when available).




(*Authors note – select Next when available).




(*Authors note – select Install when available).




(*Authors note – select Next when available).



(*Authors note – select Close when available).




Run the SQL Management Studio.


(*Authors note – select Start | All Programs | Microsoft SQL Server 2008 and right mouse click on SQL Server Management Studio. Select Run as administrator from menu that appears. Accept UAC after this).



Connect to SQL instance call Express that was created in Step 4.


(*Authors note – should actually be Step 6 I believe).




Right mouse click on Databases and select Attach from the menu that appears.




(*Authors note – select Add).



This is what the Microsoft doc says:


“In the Attach Database dialog box, browse to the location where you transferred the .mdf and .ldf files in “Step 2: Back up the Windows Internal Database files,” select the ShareWebDb.mdf file for the database that you want to attach, and then click OK.”


(*Authors note – navigate to c:\windows\sysmsi\ssee\mssql.2005\mssql\data and select ShareWebDB.mdf.

The issue with the Microsoft document is firstly, I think it should read Step 4 – Back up the Windows Internal Database files, not Step 2. Secondly, I believe you should not be attaching these as they are backups, the original content database which you detached in Step 9 are actually located in c:\windows\sysmsi\ssee\mssql.2005\mssql\data. It is these original WSS v3 content databases you should be using).



(*Authors note – select OK).




(*Authors note – select OK).




(*Authors note – if you now open Databases you should see ShareWebDb).




(*Authors note – To manage your SQL 2005 Embedded databases via the SQL Management Studio select File | Connect Object Explorer.




Enter \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query in the server name and press Connect.




You should now see the two SQL instances – 2008 at the top and 2005 Embedded below as shown above).