Missing data on sharePoint 2007 after restoring

Posted on 2010-08-28
Last Modified: 2012-05-10
Our sharepoint server recently crashed with some of the other servers but the SQL server that the sharepoint was writing to never crashed.
We restored a sharepoint server that is a week older but using the same SQL server that did not crash and should be having all the sharepoint data but what we have noticed is that we are missing a week worth of data. Is there anyway that we can get the week worth of data from the sql?
Question by:Atouray
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 51

Accepted Solution

Ted Bouskill earned 500 total points
ID: 33554093
Sharepoint has a design flaw that makes restoration (or cloning) a farm very difficult.

As you likely know Sharepoint created 7 or more databases that all represent a complete installation.  All of them have to remain in sync in order to keep the installation healthy and almost everything that represents the farm is stored in those databases.

The Sharepoint server itself stores very little information about the farm but does have a configuration cache.

I hope you are backing up your non-Administration content databases as well as your SSP configuration database.  In some cases those are what are required to recover from a severe disaster.

If you restored an image of the sharepoint server that isn't a good strategy and has likely confused the installation and I hope it hasn't lost the data.

To be honest I think you should contact Microsoft Support to be sure you don't lose that last week of data and have them explain safer scenario's for executing disaster recovery which sadly sometimes requires rebuilding the installation then attaching the backups of the SQL databases.

Author Closing Comment

ID: 33700227
Not full round solution.
LVL 51

Expert Comment

by:Ted Bouskill
ID: 33703475
There isn't always a solution and sometimes the 100% correct answer is "It can't be done" or "Isn't possible"

In this case restoring the old Sharepoint server images and connect them to the current databases was not a recommended restorations strategy (contact Microsoft if you don't believe me)

You cannot recover the data from SQL directly.  You would have had to rebuild your Sharepoint installation from scratch and restored the content databases into the new installation to recover the data.  However, once you attached the old Sharepoint servers to the current databases you likely lost that data.

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

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…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor ( Top Charts is a view in which you can set seve…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

717 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