Upgrade a stand-alone installation on a domain controller by using RBS (database attach) (SharePoint Foundation 2010)

  • Article

 

Applies to: SharePoint Foundation 2010

This article discusses the upgrade procedures that are required to upgrade from a stand-alone Windows SharePoint Services 3.0 system that is running on a domain controller to Microsoft SharePoint Foundation 2010 with Remote BLOB Storage (RBS). We typically recommend that you use RBS if the content databases are 4 gigabytes (GB) or larger.

Important

We strongly recommend that you read the article Upgrading from a stand-alone installation of Windows SharePoint Services 3.0 to SharePoint Foundation 2010 when content databases exceed 4 GB (RBS) for important information and recommendations about how to upgrade from Windows SharePoint Services 3.0 to SharePoint Foundation 2010 with RBS.

You can use RBS to move the storage of binary large objects (BLOBs) from database servers to commodity storage solutions. RBS is an add-on that can be applied to SQL Server 2008 Express and to SQL Server 2008.

The implementation of RBS that is discussed in this article uses the SQL Server FILESTREAM provider. For more information about RBS and the FILESTREAM provider, see Overview of RBS (SharePoint Foundation 2010).

In SharePoint Foundation 2010, the content databases are stored in SQL Server 2008 Express and have a maximum size of 4 GB per database. Because Microsoft SQL Server 2008 R2 Express supports content databases that are up to 10 GB, we recommend that you install SQL Server 2008 R2 Express to support the content databases.

This article is not a comprehensive guide to upgrading to SharePoint Foundation 2010. Instead, it refers you to the articles you should read to perform the upgrade. This article contains the additional steps that are required to install and implement RBS on a domain controller installation of SharePoint Foundation 2010.

Before beginning the upgrade process, read the following articles and create an upgrade plan:

Procedures in this article:

  • To prepare for the upgrade to SharePoint Foundation 2010 with RBS on a domain controller

  • To install SQL Server 2008 Express R2

  • To install RBS

  • To install and SharePoint Foundation 2010

  • To migrate the content database to RBS and complete the installation

To prepare for the upgrade to SharePoint Foundation 2010 with RBS on a domain controller

  1. Verify that the user account that is used to perform the upgrade and installation meets the requirements listed in Initial deployment administrative and service accounts (SharePoint Foundation 2010).

  2. Verify that the user account is a member of the Administrators group on the local computer.

  3. Confirm that the hardware configuration supports SharePoint Foundation 2010. For more information, see Hardware and software requirements (SharePoint Foundation 2010).

  4. Verify that the available disk space meets the following requirements:

    • Available disk space is at least two times the size of the largest content database.

    • Available disk space is equal to or greater than the sum of the sizes of all content databases.

  5. Perform the pre-upgrade tasks that are discussed in the article Perform pre-upgrade steps (SharePoint Foundation 2010). These are as follows:

To install SQL Server 2008 Express R2

  1. Download SQL Server 2008 R2 Express from Microsoft SQL Server 2008 R2 Express Edition (https://go.microsoft.com/fwlink/p/?LinkID=189418).

  2. Follow the on-screen instructions to install SQL Server 2008 R2 Express on the domain controller.

    For more information about how to install SQL Server 2008 R2 Express, see How to: Install SQL Server 2008 (Setup) (https://go.microsoft.com/fwlink/p/?LinkID=186119&clcid=0x409).

    Accept the default settings for most of the installation options. You should specifically accept the following options:

    1. On the Feature Selection page, you can select the components for the installation. Be sure to select SQL Server Management Studio as a feature to install.

    2. On the Instance Configuration page, specify whether to install a default instance or a named instance. If you create a named instance, note the instance name because you will need this name in a later procedure in this article.

    3. On the Server Configuration — Service Accounts page, you must specify login accounts for SQL Server services. You can assign the same login account to all SQL Server services, or you can configure each service account individually. You must use a domain account as the login account for the SQL Server Database Engine.

    4. On the Database Engine Configuration page, make sure that the domain account that is used for this installation is listed as a SQL Server administrator.

To install RBS

  1. Go to https://go.microsoft.com/fwlink/p/?LinkID=177388 (https://go.microsoft.com/fwlink/p/?LinkID=177388) to download the RBS_X64.msi file.

    Important

    You must install the version of RBS that is included in the SQL Server Remote BLOB Store installation package from the Feature Pack for Microsoft SQL Server 2008 R2. The version of RBS must be 10.50.xxx. No earlier version of RBS is supported for SharePoint Foundation 2010.

  2. Open the folder that contains the file, and then double-click RBS_X64.msi to start the Install SQL Remote BLOB Storage Wizard.

  3. In the Install SQL Remote BLOB Storage Wizard, on the Feature Selection page, expand Server, click the down arrow next to Execute scripts, and then click Entire feature will be unavailable.

  4. Expand FILESTREAM Provider, expand Server, click the down arrow next to Execute scripts, and then click Entire feature will be unavailable.

    Note

    The database that will host the scripts does not yet exist because it will be created during the database upgrade process. The Execute scripts option will be installed automatically during the installation of SharePoint Foundation 2010.

  5. Complete the wizard by using the default values.

    During the installation, a dialog box appears that describes an RBS Maintainer task. Click OK in that dialog box to continue with the installation.

To install SharePoint Foundation 2010

  1. Uninstall all previous versions of SharePoint Products and Technologies that exist on the domain controller by using Control Panel.

  2. Install SharePoint Foundation 2010 by following the instructions in Install SharePoint Foundation 2010 on the farm servers. During the installation, you must use the database instance name that you created in Step 2 of the procedure To install SQL Server 2008 Express R2. If you used the default named instance in that step, you must enter it in this step as "SQLExpress". If you used the default instance, you must type " " here instead of using the default SQLExpress named instance.

    Note that you are creating a new installation of SharePoint Foundation 2010. You are performing a database attach upgrade, not an in-place upgrade.

    Note

    After you install SharePoint Foundation 2010, do not create any Web applications until instructed to do this later in this article.

To migrate the content database to RBS and complete the installation

  1. Verify that the user account that is performing this procedure is the same user account that was used to install the farm running SharePoint Foundation 2010 and RBS.

  2. On the Start menu, click All Programs.

  3. Click Microsoft SharePoint 2010 Products.

  4. Click SharePoint 2010 Management Shell.

  5. At the Windows PowerShell command prompt, type the following command to migrate the content database to RBS:

    Move-SPBlobStorageLocation -SourceDatabase "<ContentDbName>" -DestinationDataSourceInstance "<InstanceName>"

    Where:

    • <ContentDbName> is the name of the content database.

    • <InstanceName> is the name of the SQL Server database instance name that you created in Step 2 of the procedure To install SQL Server 2008 Express R2. If you used the default named instance in that step, you must enter it here as "SQLExpress". If you used the default instance, you must type " " here instead of using the default "SQLExpress" named instance.

    You must repeat this command for each content database. Refer to the list of content databases that was generated by the Pre-upgrade checker in Step 5 of the To prepare for the upgrade to SharePoint Foundation 2010 on a domain controller with Remote BLOB Storage procedure earlier in this article.

  6. Create the Web applications to which the content databases will be attached. For information about how to create a Web application in SharePoint Foundation 2010, see Create a Web application (SharePoint Foundation 2010) or Create a Web application that uses Windows-claims authentication (SharePoint Foundation 2010).

  7. To attach and upgrade the content database to a SharePoint Foundation 2010 Web application, type the following command:

    Mount-SPContentDatabase "<ContentDbName>" -DatabaseServer "<DbServer>" -WebApplication <http://SiteName>

    Where:

    • <ContentDbName> is the name of the database.

    • <DbServer>is the name of the database server.

    • <http://SiteName> is the URL of the Web application.

    For more information, see Move-SPBlobStorageLocation and Mount-SPContentDatabase.

  8. Create or restore needed customizations onto the new system. For recommended post-upgrade steps, see Perform post-upgrade steps (SharePoint Foundation 2010).

See Also

Concepts

Plan for RBS (SharePoint Foundation 2010)
What's new in upgrade (SharePoint Foundation 2010)

Other Resources

Downloadable book: Upgrading to SharePoint Foundation 2010
Resource Center: Upgrade and Migration for SharePoint Foundation 2010