Search icon Close icon
Search icon
Subscription
0
Cart icon
Close icon
You have no products in your basket yet
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Microsoft SharePoint 2010 Administration Cookbook

You're reading from  Microsoft SharePoint 2010 Administration Cookbook

Product type Book
Published in Jan 2011
Publisher Packt
ISBN-13 9781849681087
Pages 288 pages
Edition 1st Edition
Languages
Concepts
Author (1):
Peter Serzo Peter Serzo
Profile icon Peter Serzo
LinkedIn
Peter Serzo is an English major from Kent State who started his technical career with EDS out of college. 20 years later, all as a consultant, he is a national speaker regarding to SharePoint having worked at organizations of all sizes. His next challenge is to bring SharePoint to children and teach them. He has been working with SharePoint since 2003 in companies such as Microsoft, Ford, ADP, and many others throughout the United States. He is a Senior SharePoint Architect for High Monkey Consulting. The name refers to an old Jamaican proverb that means the higher up you go, the more responsible you must be; High Monkey takes pride in its accountability and excellence of work in regards to its clients' needs.
See other products by Peter Serzo

Table of Contents (17) Chapters

Microsoft SharePoint 2010 Administration Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
1. Preface
1. Upgrading and Configuring SharePoint 2010 2. Service Applications 3. Farm Governance 4. Site Administration 5. Monitoring and Reporting 6. Search 7. Security Administration: Users and Groups 8. Content Management 9. Social Architecture 10. Backup and Restore 11. Performance Monitoring

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.

arrow left Previous Chapter
Chapter 1 of 17
Next Chapter arrow right
You have been reading a chapter from
Microsoft SharePoint 2010 Administration Cookbook
Published in: Jan 2011 Publisher: Packt ISBN-13: 9781849681087
© 2011 Packt Publishing Limited All Rights Reserved
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Sign up now
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Start free trial
Renews at $15.99/month. Cancel anytime}

Authors (1)

Profile icon Peter Serzo
LinkedIn
Peter Serzo is an English major from Kent State who started his technical career with EDS out of college. 20 years later, all as a consultant, he is a national speaker regarding to SharePoint having worked at organizations of all sizes. His next challenge is to bring SharePoint to children and teach them. He has been working with SharePoint since 2003 in companies such as Microsoft, Ford, ADP, and many others throughout the United States. He is a Senior SharePoint Architect for High Monkey Consulting. The name refers to an old Jamaican proverb that means the higher up you go, the more responsible you must be; High Monkey takes pride in its accountability and excellence of work in regards to its clients' needs.
Read more
See other products by Peter Serzo

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
Engineering Manager's Handbook
Engineering Manager's Handbook
Engineering Manager's Handbook is a comprehensive guide for managers to excel in their role, foster customer-centric digital products, learn leadership, team building, and balancing technical work with management. You’ll also explore how to develop trust, authority, and collaboration to drive success and make a lasting impact.
Sep 2023 9 hours 16 minutes
C++ Game Animation Programming
C++ Game Animation Programming
Video game characters have a fascinating history, evolving from simple 2D sprites to high-polygon 3D models. Take a look behind the curtain and learn how to build a 3D renderer, load character models, play animations and blend between them, and create large crowds of animated people with this comprehensive C++ game animation programming guide.
Dec 2023 16 hours 0 minutes
Gamification for Product Excellence
Gamification for Product Excellence
This book helps you to take your product management strategy to the next level by standing out in crowded markets. Along with boosting user adoption rates by creating engaging products that incorporate playful elements, learn gamification theory and how to integrate it into your design, product development, and product management processes.
Sep 2023 11 hours 40 minutes
Supercharging Productivity with Trello
Supercharging Productivity with Trello
Supercharging Productivity with Trello is the ultimate guide for anyone looking to boost their productivity with digital tools. Whether you're new to Trello or a seasoned professional, this book covers everything from core features to advanced automation, and Power-Ups.
Aug 2023 11 hours 24 minutes
Automate It with Zapier and Generative AI
Automate It with Zapier and Generative AI
This comprehensive guide takes you through the concepts of business process automation, showing you how Zapier can facilitate it without having to write code and helping you to boost productivity. You’ll learn how to save time, reduce costs, and make your business recession-proof by using Zapier to automate tasks in your cloud-based business apps.
Aug 2023 23 hours 32 minutes
Scoring to Picture in Logic Pro
Scoring to Picture in Logic Pro
In this book, you’ll explore a variety of techniques to synchronize music to picture using Logic Pro. Though this is not a technical manual, it will teach you how to make the best use of Logic Pro and how to wield this technology to maximize your potential when scoring to picture.
Sep 2023 13 hours 44 minutes
Mastering Information Security Compliance Management
Mastering Information Security Compliance Management
This concise book equips you with the knowledge and practices needed to establish and maintain an effective information security management system. The chapters provide insights into ISO/IEC 27001/27002:2022, risk management, ISMS development, incident management, audit processes, and strategies for continuous improvement.
Aug 2023 7 hours 52 minutes
Implementing Atlassian Confluence
Implementing Atlassian Confluence
Implementing Atlassian Confluence provides both a high-level overview and an insightful path for remote collaboration with Atlassian Confluence. With this multi-layered yet practical guide, you’ll be able to set up Confluence-based collaboration with minimum external consultancy services to ensure smooth and close coordination between teams.
Sep 2023 13 hours 32 minutes
R Bioinformatics Cookbook
R Bioinformatics Cookbook
This book takes a unique problem–solution approach to handling complex tasks in the bioinformatics domain using different datasets present in the book. With the help of real-world examples, you’ll learn to put each independent recipe to use to tackle problems in the field of bioinformatics.
Oct 2023 13 hours 12 minutes
Build Your Own Metaverse with Unity
Build Your Own Metaverse with Unity
Build Your own Metaverse with Unity is a practical guide for developers to create their own metaverse - a virtual world with infinite possibilities. It empowers you to identify gaps in existing metaverses and improve upon them, enabling you to shape your virtual world.
Sep 2023 19 hours 32 minutes
Right arrow icon