Wednesday, March 14, 2007

SharePoint 2003 server upgrade to MOSS2007

This Upgrade approach can be used in multiple cases as: test upgrade, moving to new hardware upgrade and basically in any other case. To use the approach you need to have virtual server with Sharepoint 2003 installation.
Conditions:
  1. VS SPS 2003 should be exactly patched as production one.
  2. Same SQL database server can be used, but if database server is different - it should be patched as production one.

Steps:

  1. Backup production SPS 2003
  2. Restore backuped databases to a SQL server under different name - if you will use same SQL server for the process.
  3. On VS SPS 2003 install post sp2 hotfix http://support.microsoft.com/?id=897722 to get databaserepair option for stsadm.
  4. Run stsadm -o databserepair on all virtual servers content databases, command line will be like "stsam -o databaserepair -url http://sps.company.com -databasename sps_site". http://support.microsoft.com/kb/918744 . In my cases I did not have any orphane objects, I beliave if you do - you need to fix the database.
  5. Do not use full-text index on any database, if an index exists - delete the index file and disable the indexing on the database (database properties - files option).
  6. Run prescan.exe tool from MOSS2007 installation CD, run as: "prescan.exe /all" any other option so far gave me an error like something wrong with uri.
  7. Fix any error, if you run prescan - failed, but if you will run MOSS2007 installation without fixing errors it can give you more specific error log.
  8. After main upgrade finished you need to check sharepoint timer service - it should be running, and if you have WSS V2 sites very possble you will need to run "psconfig -cmd upgrade -inplace b2b -wait -force" from "\...\12\bin" to finish provisioning SSP(s)

No comments:

Post a Comment