Solved

SBS 2008 WSS3 WSS_Content Migration

Posted on 2011-03-10
3
580 Views
Last Modified: 2012-06-27
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.
0
Comment
Question by:sparky2156
  • 2
3 Comments
 
LVL 12

Expert Comment

by:Hairbrush
ID: 35095137
Hi Sparky

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?
0
 
LVL 3

Accepted Solution

by:
sparky2156 earned 0 total points
ID: 35505747
Only way we could resolve this issue was to restore the server from a backup, backup the sharepoint site with stsadm (http://technet.microsoft.com/en-us/library/cc512094(office.12).aspx)

Then restoring this with the stsadm command on the live server

Everything worked fectectly - should have done this in the first place, saved so much time
0
 
LVL 3

Author Closing Comment

by:sparky2156
ID: 35711354
Resolved myself.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now