techiet
asked on
Sharepoint Files location
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!
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!
Try searching for *.mdf across your computer to ensure its not there, Do you have any backup of machine or sql ?
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\Da
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/