Is it recommanded to implemen a Virus Scanner on the SQL/NAS Server?

I need a recommadation. Thanks a lot

No Data
  • Normally I would disagree. If you want to do that, because of different reasons, then you have to setup the virus scanner in certain way.

    You should setup exceptions for all sql database / transaction logs (include tempdb) and the temp dir of the nst. If you dont do this, then you can create huge performance issue, because of the scanning of the virus scanner.

    I would recommend separate server with restricted access and no internet access. Then you dont need a virus scanner.

    best regards
No Data