Хранение PDF-файлов в двоичном виде в sqlserver
Now I am considering options to store the documents on the server I'll have PDF documents mostly around 1 Million or so,those will store into a SQL Server table I am aware that I will reach the 8TB, I'm not sure about limit .mdf size of SQL Server Enterprise edition. After the PDF files are stored they can be downloaded and viewed via browser after entering the related order number. Here is some additional information: -The PDF files will have a size of around 1-2 MB. each -SQLServer 2016 Enterprise -2TB SSD*4
Что я уже пробовал:
my table of orders by a varbinary(MAX) column and store the PDF document directly into that binary field.