Book Image

Microsoft SharePoint 2010 Administration Cookbook

By : Peter Serzo
Book Image

Microsoft SharePoint 2010 Administration Cookbook

By: Peter Serzo

Overview of this book

Collaboration and content management are the major business needs of every organization in this increasingly global and connected environment. Microsoft SharePoint is a solution to these needs that offers a software platform that facilitates collaboration and provides content management features for the effective implementation of business processes. With a vast amount of functionality available with SharePoint, it is easy to get confused in carrying out administrative tasks. Microsoft SharePoint 2010 Administration Cookbook starts off by demonstrating the various upgrading and post-upgrading tasks to be performed in SharePoint 2010. Next come recipes for managing SharePoint service-level applications and for monitoring the SharePoint environment. The book introduces one of the best new tools that should be in your arsenal, PowerShell, and the commands you will need to script your tasks with Powershell. Collaboration and content management are the most important features of SharePoint and this book contains many recipes that focus on improving them. Enterprise monitoring and reporting are also covered in detail so that you can ensure that your SharePoint implementation is up and running all the time. You will find recipes to manage and customize SharePoint Search. When you are half way through the book, you will explore more advanced and interesting topics such as customizing and securing the SharePoint environment. You will learn to extend SharePoint to include features similar to social networking sites such as Facebook and Twitter. Lastly, the book covers backup and recovery solutions for SharePoint so that you can ensure that your system is protected from data loss and virus attacks.
Table of Contents (17 chapters)
Microsoft SharePoint 2010 Administration Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface

Upgrading with minimal downtime


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.

Getting ready

WSS 3.0/MOSS 2007 installation must have the Office 2007 Service Pack 2 installed.

How to do it...

  1. 1. Open Microsoft SQL Server Management Studio.

  2. 2. Log in to the WSS 3.0/MOSS 2007 database server.

  3. 3. In the Object Explorer, click the folder named Databases.

  4. 4. Find the correct content database. By default, this is called wss_content_{guid}.

  5. 5. Right-click on correct content database, and select Properties.

  6. 6. Under the Options selection, scroll down until the main window with the State section is visible. Refer to the next screenshot:

  7. 7. Change the Database Read-Only property to True from the existing value of False.

  8. 8. Click OK.

How it works...

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.

See also

  • Upgrading MOSS 2007 to SharePoint 2010.