locked
SharePoint 2003 contentMigration upgrade: Running Prescan.exe in WSS3.0 RRS feed

  • Question

  • Morning all,

    Here's my scenario.  I'm taking care of a SharePoint 2003 SP2 upgrade to MOSS 2007.  We don't need the config data but only want to retain the collaboration sites; this the database/content migration route was picked.  I ran the prescan.exe on the farm, fixed the issues (only orphan objects), moved the DB  between SQL Servers and tried to restore the DB to my MOSS farm on a dedicated Web App that has it's default content database cleared.  Then I generate this error: -

    "The pre-upgrade scan tool has not yet been run on this database SPContentDatabase Name=SPS_2003_Sites Parent=SPDatabaseServiceInstance. You must run the pre-upgrade scan tool before you can continue with the upgrade process. Run the tool from the following path: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\prescan.exe"

    Running the utility in the commandline then advises me that I need a WSS 2 environment.  Now the only WSS 2 environment I have is the old production one, so I'm not keen to do too much on this.  I ran the prescan tool on this, deleted the orphan objects and assumed that a flag would be set so the contentDB would be upgraded with no problem once I'd taken the backup.

    So, I'm seeking any suggestions as to what next.  I suspect I'll have to set up a SharePoint 2003 mirror, run all the prescan work there again, and then move the database into my 2007 mirror, but if this could be avoided, It would be great.

    Cheers
    Steven


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Tuesday, June 28, 2011 8:14 AM
    Answerer

Answers

  • EDIT: I've answered my own question so I'll mark this as an answer.  A new thread will be started for my next problem.

    Ok, an update,  It seems I can run a SQL Query to set the flag that Prescan.Exe does:

    Sites SET BitFlags = 262144

    I'll let you all know how this works out


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    UPDATE

    Tuesday, June 28, 2011 8:18 AM
    Answerer

All replies

  • EDIT: I've answered my own question so I'll mark this as an answer.  A new thread will be started for my next problem.

    Ok, an update,  It seems I can run a SQL Query to set the flag that Prescan.Exe does:

    Sites SET BitFlags = 262144

    I'll let you all know how this works out


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    UPDATE

    Tuesday, June 28, 2011 8:18 AM
    Answerer
  • Thank you for posting your answer.  I faced the same problem, took me many hours before finding your post which resolved the issue I had.

    Tuesday, February 7, 2012 9:18 AM