SQL Server 2005 with Antivirus

Dear all

Network people in the company insist on having anti virus on ALL servers (we have 8 servers , 3 servers for SQL Server 2005)

Does anyone have a recommendation for good A/V software that will play nice ?
is there any specific configurations from SQL Server side or A/V ?

asked Nov 13 '12 at 02:53 PM in Default

Troy_2012
600 ● 2 ● 11 ● 19

Thanks to all

Nov 13 '12 at 03:37 PM Troy_2012

Troy, are you having trouble with the process of marking your questions as answered? If you are clicking the tick/check mark to the left of a question and nothing it happening then there may be an issue we need to review. Marking a question as answered, as the one that helped you the most, will guide others to a quick solution if they have the same scenario as your question explains.

Let us know if this isnt working for you.

Nov 16 '12 at 01:08 PM Fatherjack ♦♦

No I don't have any problem

Nov 16 '12 at 01:15 PM Troy_2012

So I've got to ask, why dont you mark any of the answers as correct? You have asked 9 questions and none of them have yet been marked as answered satisfactorily. I'm worried that people will stop helping you if you don't give them the credit of acknowledging their assistance.

Nov 16 '12 at 01:23 PM Fatherjack ♦♦

If you are saying that no single answer was the complete solution then I understand your thoughts but select the one that helped you the most. No one here will judge you on which one you pick. Whether you consider effort from the answerer, content of the question or some other factor is not a big issue. Others with problems will get a guide to what was best for you by following your selection of the best answer. Often it is the one that has most votes but that is not necessarily the case.

I would really appreciate it if you can take 2 or 3 minutes to review your questions and mark a few as having been answered successfully please.

Nov 16 '12 at 01:35 PM Fatherjack ♦♦

show 4 more replies

(comments are locked)

6 answers:

Here are some thoughts.

File Type Exclusions:
.MDF SQL Server data files
.LDF SQL Server data files
.NDF SQL Server data files
.BAK SQL Server backup files
.TRN SQL Server backup files

Directory Exclusions:

\Program Files\Microsoft SQL Server\MSSQL$instancename\DATA\
Data files.

\Program Files\Microsoft SQL Server\MSSQL$instancename\BACKUP\
Backup files.

\Program Files\Microsoft SQL Server\MSSQL$instancename\FTDATA\
Full-text catalog files.

\Program Files\Microsoft SQL Server\MSSQL.X\OLAP\Data\
Folder that holds Analysis Services 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.

answered Nov 13 '12 at 04:09 PM

Tim
31.7k ● 23 ● 32 ● 116

I'd also add any file type created by any third party Backup tool to avoid CPU pressure when backup or restore actions take place

Nov 14 '12 at 01:20 PM Fatherjack ♦♦

Did this answer your question properly?

Nov 15 '12 at 07:24 PM Tim

Yes Tim everything is clear now.

Nov 16 '12 at 11:23 AM Troy_2012

Good to hear @troy_2012. If you have noticed some questions show green. Those are the questions that people have chosen as an answer to their question. If you could make sure to do that on the questions you ask that have been answered that would be great.

Nov 16 '12 at 11:34 AM Tim

@troy_2012 - Tim's advice to mark an answer as correct is part of the reason this site succeeds. Other users can search here for their issue and ones marked as answered will help their confidence in accepting the solution as a viable one. Pass it forward!

Nov 16 '12 at 01:04 PM Blackhawk-17

(comments are locked)

I don't have any specific recommendations per say, however I'd probably say to look over this document from Microsoft to ensure that you ask the right questions of the vendors

http://support.microsoft.com/kb/309422

Hope this helps!

answered Nov 13 '12 at 02:58 PM

JohnM
4.6k ● 1 ● 3 ● 7

(comments are locked)

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

Blackhawk-17
10.5k ● 23 ● 29 ● 34

(comments are locked)

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