Sharepoint 2010 Unattached Content Database Recover doesn't access all sites

A client says he deleted a sub-site from a site collection, which caused the entire intranet to become unavailable (Page Not Found errors when navigating to any part of the site).

I'm using "Unattached Content Database Data Recovery" in Central Administration. I can open the db, but only 2 sites are available for selection (both personal sites). However if I open the database in SQL Server Management Studio, I can see content for all the other sites in the collection. Is there any way to access this content?
anserisAsked:
Who is Participating?
 
KoenVostersCommented:
I understand, but I would have to ask how important this information is, or what time they need to set it up again. Because as I see it now, if there is a fix, it will put the SharePoint farm in an unsupported state.
0
 
Justin SmithSr. System EngineerCommented:
No.

So you aren't running regular backups?

0
 
anserisAuthor Commented:
I am. This client isn't.

Yes, that was my first question to him, too.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
FastFngrzCommented:
He has no backups?  Bu_hahaha..  Good luck with that!  No sql backups, no stsadm backups, no powershell backups, no 3rd party backups, no snapshots/images of the vm?   Sorry buddy, look at expensive 3rd party tools to do sharepoint database recovery..  
0
 
KoenVostersCommented:
Have you tried attaching the content db to another farm just to be sure that you can't access the content?
0
 
anserisAuthor Commented:
KoenVosters: yes, tried that with the same result.

I don't have much sympathy for this guy either, but it's interesting that the information is apparently still in the database. I didn't want to dismiss this entirely without asking around.
0
 
KoenVostersCommented:
Did you manage to fix it?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.