?
Solved

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

Posted on 2011-03-08
13
Medium Priority
?
627 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:softecsolutions
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
13 Comments
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 1500 total points
ID: 35068345
Luckily you have the mdf (and hopefully ldf) files, so there is some hope.

You need to attach these mdf databaes back into SQL first off.  Only attach the web app content db's, don't bother with the config or admin or service app databases (for sake of ease).

Go ahead and run the SP config wizard to create a new farm.  Open up Central Admin and manually create your service apps and web apps to match the previous environment.

Once your web apps are created, restore the databases from Central Admin - App Management - Content Databases.  You can remove the db's that were created when you made the new web apps.

So the end result will be a new farm with new web apps with your old databases attached to them.  
0
 
LVL 1

Author Comment

by:softecsolutions
ID: 35068429
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.
0
 
LVL 4

Accepted Solution

by:
Pstry earned 500 total points
ID: 35068433
I believe that restoring files does not make SharePoint work. What you should do is:

Install SharePoint with the same configuration (names are most important)

and...

If you do have full farm backup: restore SharePoint from backup
if you do not have farm backup:

Create the same application(s)
Delete content databases: Central Administration -> Application Management -> Manage Content Databases -> Select application and database -> Select 'Remove content database' -> Confirm
Restore databases from backup on your SQL Server
Make sure that new logins are mapped correctly to database users (might not be necessasry if you restore AD)
Attach database to existing application(s): Central Administration -> Application Management -> Manage Content Databases -> Select application -> Add a content database -> Enter existing database name and confirm. Note: depending on situation stsadm -o addcontentdb command or Mount-SPContentDatabase powershell cmdlet may be required instead.

I will not try to restore files. Of course - if you previously had some custom features or solutions installed - install them again. If you modified web.config - try to apply changes (line by line, do not replace content).

Your search settings, profiles, BDC and so on will be lost. However - almost all of these can be restored manually.

0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 14

Expert Comment

by:KoenVosters
ID: 35069327
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.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 35069391
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.
0
 
LVL 1

Author Comment

by:softecsolutions
ID: 35069655
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.
0
 
LVL 1

Author Comment

by:softecsolutions
ID: 35073158
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.)
0
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 1500 total points
ID: 35073176
Through SQL manager.
0
 
LVL 1

Author Comment

by:softecsolutions
ID: 35073195
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?
0
 
LVL 1

Author Comment

by:softecsolutions
ID: 35074054
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.
0
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 1500 total points
ID: 35074082
Farm admin account needs owner role on all db.
0
 
LVL 1

Author Comment

by:softecsolutions
ID: 35074518
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.
0
 
LVL 1

Author Closing Comment

by:softecsolutions
ID: 35074588
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.
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Suggested Courses

752 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