SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have inherited a SharePoint system with no documentation on the infrastructure. I have determined so far that this system is MOSS2007 Foundation, that the IIS site sits on one server while the SQL database sits on another, but not much more.

There are files in a "document library" that clients and employees can both post files to. I do not know where these actual files reside within our network once they are uploaded to the Portal. How do I determine this?

Additionally, is there a tool I can use to give me all the information regarding my SharePoint infrastructure, or a reference where I can learn to find these components on the existing setup?

share|improve this question
up vote 1 down vote accepted

Files uploaded to a SharePoint document library normally reside in the SQL database itself, unless there is a mechanism in place to store them outside SQL (specifically, a "Remote Blob Storage" provider). SharePoint splits its databases by type of use. For a web site, the database is normally named "WSS_Content_" but the previous administrator could have named it differently.

On the server with the IIS site you should have Central Administration in the start menu. You can access it with the farm administrator account, and in there you will find a list of all web applications, and for each a list of web site collections. Your document library can be on any of them. If you want to find specifically which database, you will first need to locate the parent web site and parent web application, then in Central Admin you can see which Content Database is used by which web app. Your best bet is to find out which URL the clients access and work your way up from there.

Central Administration will provide you with a lot of information about your farm.

share|improve this answer
Is there a way to determine the "Farm Administrator Account?" If not, can I use my DA account? – sammarcow Mar 10 '12 at 19:25
DA account? Open your Computer Management console on the SharePoint server, you should have groups named WSS_<something> (WSS_ADMIN, WSS_WPG, WSS_RESTRICTED_WPG_V4). The members of those groups are either the installation accounts, admin accounts or both. See also… – Louis Mar 10 '12 at 20:34

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.