January 22, 2007 at 11:42 am
I have received a database from another agency which contains varbinary fields of .doc- and .pdf-type documents. Do I need to take any special precautions other than our standard virus protection programs to ensure I am not releasing a virus if I open/view such a field? (I'd rather be paranoid than clean up the mess.)
Thanks.
January 22, 2007 at 12:04 pm
I don't know any software which scans/detects virus in documents store in tables...
It is always better to protect to your servers using virus protect softeares...
MohammedU
Microsoft SQL Server MVP
January 22, 2007 at 2:13 pm
Mohammed -- Many thanks. I think so to, and we are as protected as possible that way. I just wanted to run this by more experienced SQL folks.
Joseph
January 23, 2007 at 10:41 am
Usually you exclude the database files (mdb and ldb) from virus scanning, and there is no normal interaction between the virus scanner and SQL Server database I/O. But if you are writing the documents to a temp file so they can be opened by the target application, they should get checked by the virus software like any other file open operation. Assuming the temp file is not in a folder that was excluded from scanning.
January 23, 2007 at 10:51 am
Scott --
I've checked with our network team and we have ample virus-protection coverage. This is the first time I've considered this question; from the responses here at sqlservercentral and elsewhere, looks like we are 'covered' to open our documents and write them to disk as planned, catching any viruses that were not trapped by our client before storing in their database.
Thanks for helping my understanding by your reply.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply