Solved

Sharepoint 2007 reinstall

Posted on 2014-01-31
24
190 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:SiliconExpert
  • 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:SiliconExpert
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
 
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:SiliconExpert
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:SiliconExpert
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:SiliconExpert
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:SiliconExpert
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:SiliconExpert
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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

Author Comment

by:SiliconExpert
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:SiliconExpert
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:SiliconExpert
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:SiliconExpert
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:SiliconExpert
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:SiliconExpert
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

746 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now