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 ‘22.214.171.12419’ 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 v126.96.36.19939 – 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)||188.8.131.5203|
|MOSS 2007 or WSS 3.0 post-SP1 hotfix (KB941274)||184.108.40.20601|
|MOSS 2007 or WSS 3.0 post-SP1 hotfix (KB941422)||220.127.116.1100|
|MOSS 2007 or WSS 3.0 SP1||18.104.22.16819|
|MOSS 2007 or WSS 3.0 October public update||22.214.171.12439|
|MOSS 2007 or WSS 3.0 August 24, 2007 hotfix package||126.96.36.19936|
|MOSS 2007 or WSS 3.0 RTM||188.8.131.5218|
|MOSS 2007 or WSS 3.0 Beta 2 TR:||184.108.40.20607|
|MOSS 2007 or WSS 3.0 Beta 2:||220.127.116.1117|
|Office 12 (PDC image – pre-beta):||18.104.22.16811|
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