Solved

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

Posted on 2011-03-19
7
614 Views
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?
0
Comment
Question by:anseris
7 Comments
 
LVL 38

Assisted Solution

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

So you aren't running regular backups?

0
 

Author Comment

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

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

Assisted Solution

by:FastFngrz
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..  
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 14

Expert Comment

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

Author Comment

by:anseris
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.
0
 
LVL 14

Accepted Solution

by:
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.
0
 
LVL 14

Expert Comment

by:KoenVosters
ID: 35189753
Did you manage to fix it?
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Date Differences SSRS 3 66
How to download files/folders from Office 365 SharePoint? 2 95
Sharepoint 2010 Auditing for One Site 3 50
Sharepoint KB 2 73
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

786 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