Calculate Sql Server Database size to hold documents

rflorencio used Ask the Experts™

I need to store pdf documents and images in a sql server database.
It is possible to calculate the approximate space for which eg. 1 Gb of documents, which size matches the database.

Best regards
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Developer
Yup. Approximately 1 GB. Cause BLOB's are offloaded internally, but this does not require an large overhead. But you should take a look at the FILESTREAM data type first.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial