Attaching SharePoint Portal Server (SPS 2003) Content Database to MOSS 2007 – error: pre-upgrade scan tool has not yet been run on this database SPContentDatabase

Posted in: Blog, SharePoint 2007 | Jan 10, 2013 at 6:11 PM

INTRODUCTION

I’ve got an ugprade project from SharePoint Portal Server 2003 (SPS 2003) to SharePoint 2010. Looking at the articles on the Internet it seems that you can’t upgrade from SPS 2003 straight to 2010. You have to upgrade to 2007 first then 2010.

I decided to use the content database backup/restore/detach/attach approach.

When I tried to restore SPS 2003 content DB to MOSS 2007 I get the following error:

error: pre-upgrade scan tool has not yet been run on this database SPContentDatabase

After looking around in Google I came accross the following article:

http://blogs.msdn.com/b/joelo/archive/2007/05/01/your-friend-prescan-what-it-does-part-2.aspx

I haven’t run PRESCAN.EXE because the client has not had any TEST environment hence they wouldn’t want to take the risk of running PRESCAN.EXE.

The PRESCAN tool somehow updates the BitFlags column in Sites table to 262144.

SOLUTION

WARNING: Microsoft does NOT support updating records in SP database directly. Therefore do this at your own risk. For me it’s working very well and the method I suggested below works if you haven’t run PRESCAN.EXE.

It is highly recommended however that you run the PRESCAN tool first so you don’t have to fiddle around with my recommended solution below!

Run the following SQL statement:

UPDATE Sites SET BitFlags = 262144

That’s it!

Tommy

Written by Tommy Segoro

A web solution expert who has passion in website technologies. Tommy has been in the web industry for more than 10 years. He started his career as a PHP developer and has now specialized in ASP.NET, SharePoint and MS CRM. During his career he has also been in many roles: system tester, business analyst, deployment and QA manager, team and practice leader and IT manager.

View all posts by: Tommy Segoro

No Comments Yet.

You must be logged in to post a comment.

Our Services

We provides you the best Services in our themes.

Portfolio

Click on the link below to see a full list of clients which we have developed solutions and provided consultancy for.

READ MORE
[S]olution Driven and [S]imple

We are solution-centered and not application-centered.

READ MORE
[F]untastic

Being creative and having fun and yet still delivering a fantastic service is the center of our values.

READ MORE
[T]imely

TFS Consulting Services guarantees delivery that is within budget and deadline or you engage us for free.

READ MORE

As long as you have the right methodologies

We have heard a lot of complaints from our clients that IT a lot of the times give them headache. The issues range from over-budget implementation, server is too hard to maintain, application is not user friendly, features not complete and many others. If you have ever experienced similar situations, don’t worry. This is why TFS Consulting Services is here. We exist to help clients implementing a successful IT solution. We have various methodologies which we have proven working in delivering a successful IT implementation. Below is the list of some of our key service offerings:

Planning and Methodologies

Implementing IT solution does not have to be difficult. TFS Consulting Services has a lot of resources on planning and methodologies that will ensure successful delivery of your IT solution. TFS Consulting Services has been around in the web industry for more than 10 years and has experienced all the successes and failures of various type of IT deployment.

Technical Resource

Do you need a technical resource? TFS Consulting Services can also provide you with technical resource for developing ASP.NET (C# and VB.NET), SharePoint (2003, 2007, 2010, 2013) and MS CRM applications. Our resource is an Microsoft Certified Personnel (MVP) and Microsoft Certified Technology Specialist (MCTS) in all ASP.NET, SharePoint and CRM.

IT Consulting & Advice

Make sure your IT implementation is robust and scalable. TFS Consulting Services can provide consulting and advice on industry’s best practice on various web-related areas such as website security, design and usability, application-specific (such as SharePoint)’s best practice, Search Engine Optimisation (SEO), coding standards and many others.

Solution Development

Finally TFS Consulting Services provides you with solution development service. We mainly work with Microsoft technologies (ie. .NET and SQL Server), however we are also capable of developing with PHP and MySQL. If you ever need any business process automation, integration and solution development work, we are the trusted expert you should go to.

For more detailed service offerings please visit our Solutions page.

Testimonials

I’m happy to recommend Tommy as a knowledgeable and diligent developer.

Mike Stringfellow, Vivid Group

Tommy has a lot of great ideas that can be delivered into great products. It’s a pleasure working with him because he has a broad knowledge about available technologies out there and he knows what’s best for the client’s needs. He just knows how to work effectively and efficiently.

Teddy Segoro, Student Edge

I’ve worked with Tommy over the past 6 months and have found his approach to development (especially SharePoint) absolutely outstanding. Tommy goes beyond the boundries of typical software development with his ability understand what a client requires and then build it into fully fledged software solution. Coupled with his professional “Best Practice” approach, you get Continue Reading

Michael Bonham, DSC-IT