Go Premium for a chance to win a PS4. Enter to Win


Missing data on sharePoint 2007 after restoring

Posted on 2010-08-28
Medium Priority
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
  • 2
LVL 51

Accepted Solution

Ted Bouskill earned 1500 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

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

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

773 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