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.
>>Source Link
>>Blog: SharePoint Blogs
>>Publish Date: 6/3/2007 8:09:55 AM
>>Keywords: restore portal
Related Posts
>>SharePoint 2007: Publishing Page Versioning not for Web Parts #
I have a MOSS 2007 portal with some Web Parts on the Home Page. If I change the page and republish it, the old version is stored in Version History. I can Edit the Page (implicit Check Out), modify
>>Restore Production SharePoint 2003 Databases to Test Servers #
This entry is designed to walk through the steps needed to backup and restore production SharePoint 2003 databases to test servers. These steps have worked well for me especially when preparing for a
>>Move MOSS 2007 Web Application to another server #
How to migrate MOSS 2007 Web Application to across servers SharePoint Portal Server 2007 central administration provides web interface to take Web Application (formerly called portal site in SPS 2003)
>>MOSS2007 - Restore site collection using just the SQL Database #
Hello again, yes I am back again, have been working very hard over the past few weeks. Am still mega busy with lots of exciting things! Thought I"d just share with you a nice way of restoring a full s
>>Backup And Restore Errors. "conflict in writing to a web application" #
Regularly I was facing this error when restoring a web application. The error was like a"conflict occured. the "username" is curently writing to the web application". Well to solve this error you have
>>SharePoint support models #
I recently reviewed our DocAve backup statistics. Here are the results, 159913 MB data, 758 sites, 4758 webs, 32075 lists, 997766 items. It got me thinking about what it takes to support this size
>>SharePoint Manager 2007 – Restore files #
One of the new cool features of this version of SharePoint Manager 2007 (SPM2007) enables you to connect to another SharePoint configuration database. This means that you can restore files that is lo
>>SharePoint Manager 2007 – Restore files #
One of the new cool features of this version of SharePoint Manager 2007 (SPM2007) enables you to connect to another SharePoint configuration database. This means that you can restore files that is lo
>>SharePoint Manager 2007 – Restore files #
One of the new cool features of this version of SharePoint Manager 2007 (SPM2007) enables you to connect to another SharePoint configuration database. This means that you can restore files that is lo
>>Visio Models, Scenarios and Flowcharts for MOSS 2007 #
Arno posted a nice list of poster-sized docments in Visio: Models Model: Business Intelligence (http://go.microsoft.com/fwlink/?LinkID=73117&clcid=0x409 ) Model: Office SharePoint Server A