Solved

Sharepoint Files location

Posted on 2011-02-28
4
541 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
[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
  • 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 43

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

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

623 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