When I do 2007 upgrades. I typically like to restore the 2003 portal to a virtual server. What this typically means is that I need to determine the service packs on both machines, match SQL server version and service packs, etc. No matter how hard I tried in a couple of instances I always hit the same brick wall... "The database schema is too old to perform this operation in this SharePoint cluster. Please upgrade the database and try again"
Part of the problem for me is that most of the older portals I'm upgrading are running SQL 2000 with some Service Pack applied. I prefer to use SQL 2005. Depending on how proactive the IT team managing the portal was... Who knows what service packs were applied.
You can determine what version of SPS 2003 Service packs have been installed by using the system
here.
You can try using the .spb files to use the Backup/Restore utility. At a minimum, this will attach the databases to the SQL 2005 instance. However, it will likely stil fail with the same message... "Schema too old."
My solution:
Install 2003 as you normally would. Then create a new portal and name it "Temp" or "Delete Me". Open up SQL Management and look at the SystemVersion table in the Site database for the newly created portal. Jot down the version number specified in the table. Now open up the Site database of the portal you are trying to restore, open the SystemVersion table and overwrite the version specified there. Go back to Central Admin and delete the temp portal, and now restore the problem child.
It should restore without a hitch now.
Posted
06-02-2007 7:08 PM
by
wpowell