RE: sps Recovery ERROR:database schema is too old to perform

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

We solved this error with the help of Mr.Jackson who is also one of the
user's of this community.
Here are the few steps:
1) Write down the software configuration of both production and test servers.
2) if wss-sp1 or Hotfix is installed, it will not be displayed in add/remove
programs.
so we cannot trace it in add/remove programs.
3) Next thing is Start - Programs - MS sql server - enterprise manager -
expand databases - click on the default content database say(SPS01_Config_db
or the name which you gave) - click on tables - open GLOBALS table to see all
rows - in this note down the version no. [This version no. must be the sam
on both production and test servers]
4) Next goto: c:\Programfiles\common files\microsoft shared\webserver
extensions\
60\bin\ and right click - properties - version tab on following files
stsadm.exe, onetutil.dll, stswel.dll and note down the version of each file
[this should be same on both production and test server]
5) Next goto c:\program files\sharepoint portal serverbin\ and right click -
properties -version tab on MSSRCH.dll (This should also be the same on both
production and Test Servers)
6) Next open sharepoint url on production server - site settings - General
Settings -
Go to SharePoint Portal Server central administration - Portal Site and
Virtual Server Configuration-Configure virtual server settings from the
Virtual Server List page.
Note down the version next to default virtual server or the one which you
created.
(This should also match on both Production server and Test Server)
7)For Me
Production Server(GLOBALS TABLE)Version is: 6.0.2.6411
Test Server (GLOBALS TABLE) Version is: 6.0.2.5530
8) So we need to apply Wss-SP1+ Following HOTFIX on Test Server (ie) on the
restoration computer.
9) LINKS TO GET THIS HOTFIX
http://www.microsoft.com/technet/security/bulletin/ms05-006.mspx
download this"Download the update (KB887981) "and install after installing
WSS-SP1
Helpful Links to this:
KB Article: - 888839, 887981, 875358, 824721
URL:- www.kbalertz.com/kb_888839.aspx
URL:- http://support.microsoft.com/default.aspx?scid=kb;en-us;824721
URL:- http://support.microsoft.com/default.aspx?scid=kb;en-us;887981
URL:- http://support.microsoft.com/default.aspx?scid=kb;en-us;875358
HOT FIX URL:- http://www.microsoft.com/technet/security/bulletin/ms05-006.mspx

MOST IMPORTANT: - URL:- http://support.microsoft.com/kb/887981
Click on IT-Professionals  Download the update (KB887981) for HOTFIX
10) After this you need to restart the system
11) Restore the backup. Success.
12) Now see the versions everything matches perfectly.
13) Note If page is not dispalyed or DNS error occurs or cannot complete this
action read the following:
KB Article: - 834546, 841216, 871149
URL:- www.kbalertz.com/kb_834546.aspx
URL:- http://support.microsoft.com/?kbid=834546
URL:- http://support.microsoft.com/?kbid=841216

and Login as a User Not as an Administrator
and do the following: Start - Run - cmd-
C:\program files\common files\microsoft shared\webserver extensions\60\bin\>
stsadm -o Upgrade -forceupgrade.
This will take few minutes. RESTART THE SYSTEM.
After successful upgradation. Open the sharepoint Site.Success.
14) Do ask me, for any more information. I will help
15) I Really had a very hard time solving this... SO I WISH Others donot
go through this. Give me your MAIL-ID I will forward the document.

"Duray AKAR" wrote:

> I am having a similar issue.
>
> My old WSS server is burned... The mdf files are recovered from the HDD. It
> did not have SP1 installed...
>
> I am trying to use the content database on a new WSS server WITH SP1...
>
> How can I do this ?
>
> Thanks
>
> "Darbha" wrote:
>
> > The database schema is too old to perform this operation in this sharepoint
> > cluster, please upgrade the database and try again.
> >
> > I have gone through the KB article 88839.
> > our file version for sps is 11.05704.0
> >
> > How to solve this problem?
> > we are unable to restore the backup of sps
> >
> > Any Ideas! Please Help
.

Relevant Pages

  • RE: help with emergency--sql server 2000 sp4
    ... I told my myself, I need to take a look at my testing database, I suddenly I ... some my production program gives invalid object error messge. ... We have two database instances on our server. ... Your ASP program failed to execute DML operations on your SQL Server after ...
    (microsoft.public.sqlserver.odbc)
  • MOSS 2007 Database Migration from Test to Production
    ... sql server to a production sql server in a MOSS 2007 environment. ... configuration database on the wrong server. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Preserving data after structure update
    ... > I make an ASP.NET application, using MSDE as BE ... > That server has its one instance of MSDE ... > When I update the application, I have to update database too (because app ... > previously on test server, since it is replaced by new one. ...
    (microsoft.public.sqlserver.programming)
  • Re: Preserving data after structure update
    ... > I make an ASP.NET application, using MSDE as BE ... > That server has its one instance of MSDE ... > When I update the application, I have to update database too (because app ... > previously on test server, since it is replaced by new one. ...
    (microsoft.public.sqlserver.setup)
  • Re: Preserving data after structure update
    ... > I make an ASP.NET application, using MSDE as BE ... > That server has its one instance of MSDE ... > When I update the application, I have to update database too (because app ... > previously on test server, since it is replaced by new one. ...
    (microsoft.public.sqlserver.msde)