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

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

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…
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…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

831 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