How to Store Image Files in a SQL Server Database

You don’t.

Instead of storing files in SQL Server, which is a horrible idea, instead, store them in Azure Blob Storage, an AWS S3 bucket, your web server, or a file server. Anywhere but the SQL Server.

If you have some 3rd party application that absolutely must store the files in the database, configure the table that it’s using for FILESTREAM.

If you are going to restore a database with FILESTREAM data Joey has some warnings on the restore.

Denny

Share

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Trust DCAC with your data

Your data systems may be treading water today, but are they prepared for the next phase of your business growth?

Denny Cherry & Associates Consulting
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.