- Microsoft SharePoint 2010 Administration Cookbook
- Peter Serzo
- 325字
- 2025-03-31 05:26:41
The SharePoint farm administrator must minimize the impact of upgrading a MOSS 2007 farm to SharePoint 2010. How long this process takes is dependent on the size of the installation.
MOSS 2007 SP2 installed a new capability that allows an administrator to set the content database to read-only. The result of this is that users can only read from the database and cannot perform any write operation.
The advantage of this when doing an upgrade is that users can continue using the MOSS 2007 farm while the data is being upgraded on the SharePoint 2010 farm.
This recipe shows how to set a database as read-only.
- Open Microsoft SQL Server Management Studio.
- Log in to the WSS 3.0/MOSS 2007 database server.
- In the Object Explorer, click the folder named
Databases. - Find the correct content database. By default, this is called
wss_content_{guid}. - Right-click on correct content database, and select Properties.
- Under the Options selection, scroll down until the main window with the State section is visible. Refer to the next screenshot:
- Change the Database Read-Only property to
Truefrom the existing value ofFalse. - Click OK.
Once the content database is read-only, no changes can be saved to the database. The WSS 3.0/MOSS 2007 site is still available to query information to the entire user population. The database can now be backed up with confidence in the integrity of the data state.
The database can be copied to the new SharePoint 2010 SQL Server and upgraded as shown in the previous recipe. When the new environment is ready to go, perform an Alternate Access Mapping (AAM) redirect to route users to the new environment and detach the database in SharePoint 2007.
This is referred to in Microsoft Technet as a Hybrid upgrade.