Thursday, September 08, 2005

The database schema is too old to perform this operation

I was trying to restore a portal from one environment to another and receive fallowing error message in the SPS log,

Portal creation failed Microsoft.SharePoint.SPException: The database schema is too old to perform this operation in this SharePoint cluster. Please upgrade the database and try again. ---> System.Runtime.InteropServices.COMException (0x81070571): The database schema is too old to perform this operation in this SharePoint cluster. Please upgrade the database and try again.

The reason to above error message is the two environment are running different WSS versions. One environment was with out the service Pack 1 and other with the Service pack 1. Soon after I made sure that both environment are ruining the sane version of WSS, It was all working fine.

4 Comments:

At 2:27 PM, Anonymous Jaimie T said...

Hey Gayan, how did you upgrade the database version on the one that was out of date?

 
At 10:59 PM, Anonymous Anonymous said...

Create a new portal site to generate DB tables (call it 'temp'). Go into SQL Server 2005 Management Studio or SQL Server 2000 Enterprise Manager and open up the dbo.SystemVersion table for this site (in this case, temp1_SITE). Copy version number.

Go to the site DB your trying to restore, open up the dbo.SystemVersion table and overwrite version value from temp site.

Delete the temp portal site and now try to restore your site.

Worked like a champ for me.

Matt L. from Whitford

 
At 6:26 AM, Anonymous Anonymous said...

I am having a similar problem with TFS restore. Unfortunately, the systemversion is same between two servers.

 
At 11:36 PM, Blogger Jamil Haddadin said...

i am having the same problem on my SQL sp4 and SPS 2003 while am trying to restore, i tried to install the SP2 but it doesnt work.

 

Post a Comment

<< Home