June 1, 2016 at 1:34 am
Hi,
Using the file stream method. a file from the share path are taken, and it will be inserted in to the DB, this is an new feature for the replacement of traditional 'insert format' in sql for inserting the file.
If a file in the shared container any malware, if that was wrongly inserted into the db , What security measure has to be taken forward to avoid facing this type of strange scenario ?
Thanks,
Babu
June 3, 2016 at 10:46 pm
you need to let your antivirus scan the file stream folder if any virus detected should quarantine the files , if you delete those file it will end up with the DB corruption.
June 5, 2016 at 9:56 am
You don't want your antivirus to read the filestream container. You should only scan the file when it is copied to another folder. There is no concern I'm aware of for insreting an infected file into the DB. This is just a binary stream and isn't rendered in any way by SQL Server.
June 7, 2016 at 4:20 am
You don't want your antivirus to read the filestream container
Agreed!! If you are concerned about storing a virus, then most A/V products have an API that allows a .Net application to do a virus scan before the file is passed to SQL Server. If your A/V does not allow this, then it is time to get an A/V product that does.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply