Link to home
Start Free TrialLog in
Avatar of softecsolutions
softecsolutionsFlag for Canada

asked on

How do I restore a sharepoint site that was not properley backed up

Hi:
Here is the situation.
A client has about 100 users.
They have a single server that acts as a domain controller, file server and sharepoint site.
The server has 2 Zeon processors, 8 GB of ram and enough horsepower to do the job and has been doing it very well since last year.
The server is running Windows 2008 standard 64 bit, sharepoint 2010 foundations, SQL 2008 express.

During a recent (february 24th) windows update, the operating system broke and many services started to fail.  (Thanks, Microsoft)  After much effort, it was decided to install a fresh copy of Server 2008 and rebuild the active directory and install SQL and Sharepoint 2010.  A copy was saved of the inetpub folder and the SQL data folder along with a copy of all the directories & files on the hard drive.

The big question is:  Can I rebuild the sharepoint site from the data files that have been saved?

Looking forward to any positive insight.  Thanks.
SOLUTION
Avatar of Justin Smith
Justin Smith
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of softecsolutions

ASKER

Thanks for your response.  I will try this this morning, I hope.  I am still creating users, not a huge job, but takes some time.  The Sharepoint site did not have much in the way of special applications, it is just the content that had all the time and effort.  I hope this will work.
ASKER CERTIFIED SOLUTION
Avatar of Piotr Strycharz
Piotr Strycharz
Flag of Poland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Pstry, I think that is what Achilles is saying, he just misused the word restoring in his explanation. Have you identified the root cause of the problem with the update? It would be good to know the reason or at least upgrade your server to the latest version to be sure the update runs fine this time.
Correct.  The user has already installed SP again, so the next step is to run the config wizard to create the farm, as I noted.
Thank you all very much for the input.  We are still creating the ldf file to import the users with.  A bit of work, but gives us a backup of users to work with too.  As for what update went wrong, we are not entirely sure.  There was a powershell update and a couple of others.  We saved the event files and with look at them once the server is finished.  I know automatic updates should be turned off on a server and this has been a harsh reminder, but can't Microsoft be trusted to do a better job of protecting the server operating systems from a total collapse.  (I know the answer to that question), AND, why the change to operating systems that can't be re-installed over themselves?  How many times has a re-install fixed issues in the past, and Microsoft took it away.  (Thanks MS)

Anyway, thank for the quidance so far.  I will try these suggestions and anything other ideas that get posted, if necessary.  Back soon.
HI
Finnaly got a chance to work on this, now that the server is up and running.  I am missing a point, and I hope it is a small one.  How do I attach the old databases back into SQL?  (I hope this isn't too obvious.)
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Opps, it was that obvious.  But I do have one issue.  When I try to attach the old database into SQL, it fails because it already has one with the same name.  Is it an issue to rename the one I am re-attaching to?
Still working away with this.  My current road block is a security issue with the old file.  It would appear that the original file had a different users attached ot it.  I am working with SQL Manager, trying to give the new user access to the database, but when I go back to Sharepoint to add that content database, it reports that the login failed for the user.   Any thoughts.  I am not strong in SQL at all, as you may have noticed.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Yes, you are right.  Thank you.  It looks as though the site is now up and running.  At least all the content is there.  A couple of things to fine tune in Sharepoint, but it is there.  Very cool.  Thank you.  I think this puppy is about done.
Thank you both for your comments.  Pstry, your step by step solution really helped when changing the content in Sharepoint.  Ach1lles, you were very quick with responses and helpful in the SQL portion as well.  Have a great week.