Improve company productivity with a Business Account.Sign Up

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 527
  • Last Modified:

Missing data on sharePoint 2007 after restoring

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?
  • 2
1 Solution
Ted BouskillSenior Software DeveloperCommented:
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.
AtourayAuthor Commented:
Not full round solution.
Ted BouskillSenior Software DeveloperCommented:
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.
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

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.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now