SharePoint DB contents and stricture analysts

IS there a tool or command where I can see where the files on SharePoint are stored?
I'm looking too understand the structure and see where the bulk of the files are stored.
ICT EngineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Walter CurtisSharePoint AEDCommented:
There are system files that keep SharePoint running, and then you have content and user data. System files are almost totally on the local files system of the servers SharePoint is installed on.  Content is almost totally in the content databases.

Configurations and settings are almost totally in databases.

As far as a tool or command? SharePoint designer is a great tool for seeing files stored in the data base, both user files and the system files that are part of the database.

PowerShell and SharePoint cmdlets are a good way to see system information. As far as files on the local files system, the usual tools will work with those.

Hope that helps...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ICT EngineerAuthor Commented:
The problem is that everything seems to be stored in on large DB and I'm looking to fine which site inside the main site is using the bulk of the storage or to fine which sites are using which amount of resources.
0
Walter CurtisSharePoint AEDCommented:
In central administration there are built-in analysis tools that should help you. Also, download a 14 day trial of Sharegate. It will also provide those reports and you should be able to get the information you need within the trial period.

Good luck...
0
Walter CurtisSharePoint AEDCommented:
Information provided is accurate and correct.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.