Improve company productivity with a Business Account.Sign Up


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

Posted on 2011-03-19
Medium Priority
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 600 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 600 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..  
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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 800 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

595 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