SBS 2008 WSS3 WSS_Content Migration
I am having a bit an issue with sharepoint. Recently, our sharepoint server got destroyed by the KB983444 update which never completes and destroys the sharepoint config database. None of the psconfig scripts or other documented fixed online fix this issue, so as i have had to do before, i wiped out shartepoint and re-installed it cleanly.
So now i have a default sharepoint system again. What i need to do is get the lists and views from the old sharepoint database. I have a copy of the old WSS_Content database, but using the database in place of the new one results in weird and wonderful errors, and doing a backup of this database and restoring over the top of the new WSS_Content database yields no results either - just more error messages.
All i need is the lists and views back out (i could even just do with the lists to be honoust and recreate the views) - but I dont know what else to do. I don't have enough knowledge of sharepoint.
Hope someone can help.
So now i have a default sharepoint system again. What i need to do is get the lists and views from the old sharepoint database. I have a copy of the old WSS_Content database, but using the database in place of the new one results in weird and wonderful errors, and doing a backup of this database and restoring over the top of the new WSS_Content database yields no results either - just more error messages.
All i need is the lists and views back out (i could even just do with the lists to be honoust and recreate the views) - but I dont know what else to do. I don't have enough knowledge of sharepoint.
Hope someone can help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Resolved myself.
Sorry to hear that your SharePoint installation got hosed by that hotfix.
The backup you have of the old database - was it taken before or after you applied the hotfix? If it is before the hotfix, it is worth soldiering on in getting that attached in order to get the data out. If not and the content database is unreadable by SharePoint, then it may be necessary to extract what you need directly from the database.
There are some off-the-shelf tools that do this, starting with https://shop.quest.com/682/purl-recovery-manager-for-sharepoint?x-AdCode=cbShopBTNRecoveryManagerForSharePoint and http://www.sharepointrecoverytool.com/sharepoint-document-recovery
If you don't want to buy a tool... how comfortable are you with Transact-SQL and .NET programming?