Solved

Sharepoint Files location

Posted on 2011-02-28
4
535 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 500 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 42

Expert Comment

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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

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 thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

707 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

16 Experts available now in Live!

Get 1:1 Help Now