Solved

Sharepoint 2007 reinstall

Posted on 2014-01-31
24
193 Views
Last Modified: 2014-02-23
Hello ,

I have uninstall sharepoint 2007 by mistake but the good point is databases are still exist .

I can connect by management studio and find WSS_Content and configuration database.

i tried to install shapoint again as a webfront and run configuration wizard then choose to connect to existing database and able to retrive its name but i wasn't able to connect it it said "failed to connect to database"

Is there anyway to restore my sharepoint without lose anydata ?
0
Comment
Question by:Mohamed Hammad
[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
  • 12
  • 12
24 Comments
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39823870
Make sure you have the same version and update level that you had installed previously.
0
 

Author Comment

by:Mohamed Hammad
ID: 39824155
I installed the same version and the same service packs , but still couldn't connect to existing database , i made sure that the user which i connect with has privilege on the DB .

what if i copy the database file to another location and  restore a sharepoint backup since one month ago , can i restore the users data and files with just the exist database ?
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39824164
You could just create a new farm, which will create a new config db.  You'd then need to manually create your web app and specify the existing content database name.  That would bring back all your sites and data from that database.  You'd have to manually configure anything you had done in Central Admin.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 38

Expert Comment

by:Justin Smith
ID: 39824171
I'm assuming you verified the Farm Account you specified during install is a DBO on the config database and has dbcreator and securityadmin rights in SQL.  You might try to temporarily give it sysadmin rights in SQL to see if it can connect.
0
 

Author Comment

by:Mohamed Hammad
ID: 39824496
i give the user which i try to connect with to the existing database , dbowner is it not enough ?
0
 

Author Comment

by:Mohamed Hammad
ID: 39824520
attached screen shoot for the error i got when i tried to connect to database
2014-01-31-190112.jpg
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39824710
That error really looks like the config db and your install are at different patch levels.

If nothing else you can create a new farm, like I mentioned above.  I would name the config database something different, just in case.
0
 

Author Comment

by:Mohamed Hammad
ID: 39824842
i did what you mention but if you could explain in details  what should be done after create new farm with new database
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39824856
In Central Admin, create your Web Application.  Use the same URL as previously used.  When you specify the database name, specify the existing database name.  This will attach the existing sites and content to the new web app.  Afterwards, create any managed paths that you had previously.  If you had any custom solution files deployed you'll likely need to redeploy those.


Best case, that is all you need to do.
0
 

Author Comment

by:Mohamed Hammad
ID: 39826207
my sharepoint installed on hyper-v and i have an old  working snapshot since 3 monthes if i retrieve it  then everything will be back again in normal state but the problem is all user data will be outdated , so is there anyway to use the database file i got to replace the old database and return back to my original state
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39826372
I wouldn't recommend it, but you could try.  The problem is there is so much communication between the config database and other databases that sometimes snapshots don't work properly.  Since you have a single server, the risk is lower, but still there, especially if you are talking about restoring a database from the future.  And the restore will likely fail if you installed any patches between the day the snap was taken and now.

Backup content db through SQL manager, revert to snapshot, restore content db through SQL manager.
0
 

Author Comment

by:Mohamed Hammad
ID: 39827347
i Backup Wss_content database and restore it but unfortunately data is still old no new files , word , excel added to the old data restored since last 3 months.

but i found wss_content.mdf size is  GB and hwne i backup it it was 18 MB is it makes sense ?
also what if i copy wss_contenet database and overwrite the exist old one ,does it work ?
0
 

Author Comment

by:Mohamed Hammad
ID: 39834915
Nothing work from above solution , last thing i was thinking of is wss_content.mdf ,

I believe that wss_content.mdf contain all user files word,excel,.. etc ..

the question is , do i have the ability to retrieve all these files from the database ?
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39835409
Can you please list, in numbered sequence, all steps you performed?  I believe something was missed here.  TO answer your question, the only way in 2007 you can extract files from a database without attaching it to a web app is using a third party tool.
0
 

Author Comment

by:Mohamed Hammad
ID: 39838174
can you please let me know the name of this third party tool or even attache it for me
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39838876
There are lots of them for purchase. Can you list your steps?
0
 

Author Comment

by:Mohamed Hammad
ID: 39841518
1- Install sharepoint 2007  with the service pack also sharepoint service 3 with sp3
2- run configuration wizard and retrive database name but couldn't connect to it . it give me the error i mentioned above "failed to connect to database"

3- I tried to create a new database and restore the old to it but it failed.


If i missed something please list the steps that should be done to restore it .
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39841719
On number three, how did you do this exactly?  I'm getting a bit confused with the snapshots and everything.  I need to know your exact steps.
0
 

Author Comment

by:Mohamed Hammad
ID: 39849507
Sorry for delay at reply i had a critical issue to finish ,

for the third step i just create another DB and backup old wss_content from sql studio mangment and then restore it to the new wss_content but it's actual size was 34 GB and when backed it up from sql it was 18 MB ,

let me know the correct step to start from scratch .....

Now i have sharepoint uninstalled but all DB are still exist .

what should i do from the beginning ?

appreciate your  support and patience .
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 500 total points
ID: 39849905
So now you have a 34 GB WSS_Content database, and an 18 MB WSS_Content_New database?

You could run the config wizard to create a new config database.

Once in Central Admin, create a new web application and use the same URL as you previously used (you may need to manually delete sites & app pools from IIS first).  When specifying the name of the database, use WSS_TEMPDB.

Once the web app is created, go to App Mgmt - Content Databases.  Choose your web app and remove the WSS_TEMPDB.

Now click Add a Database and specify the name of your 34 GB database (WSS_Content).  This should attach it.

Test your site.
0
 

Author Comment

by:Mohamed Hammad
ID: 39853086
please if you can explain in more details how to restore it as i'm not professional in sharepoint .

my case is sharepoint uninstalled by mistake but all databases still exist .

what should i do is :

1- Install sharepoint and windows sharepoint to the latest service back as the old one .
2- create a new config DB
3- what should be done in details ?

or is there any free tool  or script can extract my data from .mdf file ?
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39853241
1. Yes.
2. Yes.  This is done when you run the config wizard after installing
3. I can't really be more specific that I was in previous comment.

I don't know of a free tool.  If you want to pay for remote assistance, I'm available.  Shoot me an email.
0
 

Author Comment

by:Mohamed Hammad
ID: 39862842
I did as you mention in step 3 and i  successfully added wss_content and found the site inside it but when open it i found it default site not my real one , and no documents exist :(

is there anything else to do after add content db ?
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39864698
Then you are working with the wrong database.  There isn't anything special you have to do after attaching.  Sites that were in the database just show up.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

733 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