MSSQL behind records management application

Sorry to sound naive, not a DBA or devloper, but I recently got copied into an architecture diagram for a new records management application, and noticed it had an MSSQL database, for records management type apps (similar concept to sharepoint), that are used to store office documents, i.e. docx, xlsx etc, surely those files dont reside in the database do they? I always viewed databases as storing only text only type data, not actual files. So if thats the case, what role would the database play (provide links to the files on a file share?)? ANy basic low tech management freindly explanation most welcome.
LVL 3
pma111Asked:
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.

Paul JacksonSoftware EngineerCommented:
Files can be stored in MS SQL as binary data and many applications do this, such as sharepoint. There are some good reasons why this can work well and some reasons why it won't.

See the following article for a good discussion:

Storing-Images-and-BLOB-files-in-SQL-Server
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
pma111Author Commented:
Can you elaborate on:

There are some good reasons why this can work well and some reasons why it won't.
0
Paul JacksonSoftware EngineerCommented:
It's probably to much of an in depth subject to go into here, when it is already documented elsewhere, as well as the link provided above see the Microsoft article below :

To BLOB or Not to BLOB
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 SQL Server

From novice to tech pro — start learning today.