Atouray
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER