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

Posted on 2011-03-19
Last Modified: 2012-05-11
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?
Question by:anseris
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 150 total points
ID: 35171670

So you aren't running regular backups?


Author Comment

ID: 35171743
I am. This client isn't.

Yes, that was my first question to him, too.
LVL 11

Assisted Solution

FastFngrz earned 150 total points
ID: 35173778
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..  
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

LVL 14

Expert Comment

ID: 35174367
Have you tried attaching the content db to another farm just to be sure that you can't access the content?

Author Comment

ID: 35174821
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.
LVL 14

Accepted Solution

KoenVosters earned 200 total points
ID: 35178425
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.
LVL 14

Expert Comment

ID: 35189753
Did you manage to fix it?

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With  eFax Corporate (, 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, f…

911 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

22 Experts available now in Live!

Get 1:1 Help Now