Have been working on a SharePoint project recently, developing some WebParts & so forth.
We have a number of VM’s, one for each developer, and was trying to restore a backup taken from the “production server” – as it’s got more content, etc.
I hadn’t been working on the project for a while, and so *MY* copy of the VM was a bit out-of date.
But – I encountered an error when trying to restore a backup of the SharePoint database – using the following STSADM command (restoring to MOSS2) :
stsadm -o restore -url http://moss2 -filename D:Backupsmoss1.bak -overwrite
The error message text is as follows :
Your backup is from a different version of Windows SharePoint Services and cannot be restored to a server running the current version.
The backup file should be restored to a server with version ‘12.0.0.6219’ or later.
My initial thoughts were along the lines of Service Pack 1 for MOSS – but I thought I’d already applied that, hadn’t I ??
And – how do I check which version of MOSS is installed ?
After some quick searching, I discovered it’s actually included as a custom HTTP variable within IIS (!).
Here’s what you have to do to see what version is running :
- Within IIS Management Console, right-click and select Properties
- And – then switch to the HTTP Headers tab (as below) :
So, there it is – I’m running v12.0.0.6039 – what now ?!?
Must pass on some thanks to Penny Coventry for a great article – How to find the level of SharePoint you are running
The article contains the following list – very useful, and goes right back to MOSS Beta2, and even includes version details for WSS 2.0 and SharePoint 2003.
For now – here’s the important numbers (for my immediate problem).
MOSS 2007 or WSS 3.0 post-SP1 hotfix (KB948945) | 12.0.0.6303 |
MOSS 2007 or WSS 3.0 post-SP1 hotfix (KB941274) | 12.0.0.6301 |
MOSS 2007 or WSS 3.0 post-SP1 hotfix (KB941422) | 12.0.0.6300 |
MOSS 2007 or WSS 3.0 SP1 | 12.0.0.6219 |
MOSS 2007 or WSS 3.0 October public update | 12.0.0.6039 |
MOSS 2007 or WSS 3.0 August 24, 2007 hotfix package | 12.0.0.6036 |
MOSS 2007 or WSS 3.0 RTM | 12.0.0.4518 |
MOSS 2007 or WSS 3.0 Beta 2 TR: | 12.0.0.4407 |
MOSS 2007 or WSS 3.0 Beta 2: | 12.0.0.4017 |
Office 12 (PDC image – pre-beta): | 12.0.0.3111 |
Sure enough, it looks like I need to apply SP1 for WSS and MOSS.
Yep – that fixed it ! Was able to restore the backup SharePoint database – back to some WebPart development – more later !
Here are a few great articles re: MOSS version’ing :
- How to find the level of SharePoint you are running
- SharePoint 2007 Versions – this includes some SQL statements to check within the SharePoint_Config database