[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Sharepoint Files location

Posted on 2011-02-28
4
Medium Priority
?
550 Views
Last Modified: 2012-05-11
I had someone make some changes to our server configuration related to DNS and such and somehow in the process our sharepoint site went down.  I cannot find any of the uploaded documents from that site anywhere on the server. Does anyone have a clue where these would have been saved and how I can access them outside the intranet?  I've looked in inetpub/wwwroot as well as done a server wide search. I'm hoping if they were somehow deleted, I can at least get them through shadow copies but need to know the directory they would have been in.

Thanks!
0
Comment
Question by:techiet
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
sabby447 earned 2000 total points
ID: 34999302
SharePoint saves all its data in database, All documents, Files, Content.. Everything goes in the database. Only thing on server is site configuration i.e. web.config and associated files i.e. dlls and some templates. Here is how you can retreive the data.

Option 1. Go to sharepoint server and connect to database using Sharepoint farm configuration and you could access your site as usual

Option 2: Download quest tool i.e. http://www.quest.com/recovery-manager-for-sharepoint/ and use that to connect to your database server and then you can extract whatever files you need from the database, Please ensure you take proper backup of database before hand

Option3 : Follow Microsoft command line to extract files, Here is the link for that : http://blogs.msdn.com/b/mwasham/archive/2008/11/20/how-to-extract-aspx-files-out-of-a-sharepoint-content-database.aspx 

Let me know if you need any further information

~Sabby
0
 
LVL 44

Expert Comment

by:zephyr_hex (Megan)
ID: 34999377
the files are in the Sharepoint SQL Database.  you hopefully can not access them directly outside your intranet because that would be a huge security issue (it would mean that you have permitted external access to your SQL Server, which is never a good idea).

the exact location of the SQL database depends on which version of sharepoint, and how you installed it.
if it's WSS 3.0 with the stand alone install (basic install), the location is:
C:\Program Files\Microsoft SQL Server\MSSQL$Sharepoint\Data

if you installed sharepoint with SQL Express (which is a bad idea, by the way), then the default install location is program files->microsoft sql server

if you have a full version of SQL installed... the default location is also program files->microsoft sql server.

however, those are just the DATABASE file locations, and you'll have to query the database in order to access your files.

my guess is that you just want access to the files.  in that case, you might look at Database Explorer:
http://blog.dreamdevil.com/index.php/2007/03/13/sharepoint_2003_database_exporter/
0
 
LVL 1

Author Comment

by:techiet
ID: 34999473
OK, it appears the database was somehow corrupted or deleted when the other changes were made.  So I'm guessing the files are gone.  THanks for your feedback!
0
 
LVL 6

Expert Comment

by:sabby447
ID: 34999502
Try searching for *.mdf across your computer to ensure its not there, Do you have any backup of machine or sql ?

0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses

640 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