Network people in the company insist on having anti virus on ALL servers (we have 8 servers , 3 servers for SQL Server 2005)
Here are some thoughts.
File Type Exclusions:
\Program Files\Microsoft SQL Server\MSSQL$instancename\DATA\
\Program Files\Microsoft SQL Server\MSSQL$instancename\BACKUP\
\Program Files\Microsoft SQL Server\MSSQL$instancename\FTDATA\
\Program Files\Microsoft SQL Server\MSSQL.X\OLAP\Data\
Folder holding Analysis Services temporary files used during Analysis Services processing \Program Files\Microsoft SQL Server\MSSQL.X\OLAP\Backup\ Analysis Services backup files \Program Files\Microsoft SQL Server\MSSQL.X\OLAP\Log\ Folder holding Analysis Services log files
NOTE: Some of the these locations are configurable and you should exclude those directories as well.Considerations when clustering: "Q:\" (Quorum drive) "%SystemRoot%\Cluster\" folder The temp folder for the Cluster Service account. Exclude the folder "%SystemDrive%\ClusterServicAaccount\Local Settings\Temp\" from scanning for example.
Exclude the SQL Server data and log files for starters.A/V software utilizes a filter driver and attempts to intercept every I/O and analyze it. This is very adverse to performance.
answered Nov 13 '12 at 02:59 PM
Regardless of the software chosen (as they will probably have a corporate preference anyway) ensure that the database files are excluded from scans, such as files with .mdf .ndf,.ldf extensions.
answered Nov 13 '12 at 03:00 PM
Kev Riley ♦♦
I've never had problems using Sophos in production systems.
answered Nov 16 '12 at 02:26 PM