x

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 ?
more ▼

asked Nov 13, 2012 at 02:53 PM in Default

Troy_2012 gravatar image

Troy_2012
750 22 34 39

Thanks to all
Nov 13, 2012 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, 2012 at 01:08 PM Fatherjack ♦♦
No I don't have any problem
Nov 16, 2012 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, 2012 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, 2012 at 01:35 PM Fatherjack ♦♦
show all comments (comments are locked)
10|1200 characters needed characters left

6 answers: sort voted first

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.
more ▼

answered Nov 13, 2012 at 04:09 PM

Tim gravatar image

Tim
36.4k 35 41 139

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, 2012 at 01:20 PM Fatherjack ♦♦
Did this answer your question properly?
Nov 15, 2012 at 07:24 PM Tim
Yes Tim everything is clear now.
Nov 16, 2012 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, 2012 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, 2012 at 01:04 PM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left

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!
more ▼

answered Nov 13, 2012 at 02:58 PM

JohnM gravatar image

JohnM
6.6k 1 3 7

(comments are locked)
10|1200 characters needed characters left

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.
more ▼

answered Nov 13, 2012 at 02:59 PM

Blackhawk-17 gravatar image

Blackhawk-17
11.9k 28 31 36

(comments are locked)
10|1200 characters needed characters left
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.
more ▼

answered Nov 13, 2012 at 03:00 PM

Kev Riley gravatar image

Kev Riley ♦♦
52.8k 47 49 76

Corporate preference? Tell me about it... where do I work? Oh yeah. Begins with "Sym".
Feb 20, 2013 at 09:48 AM ThomasRushton ♦
(comments are locked)
10|1200 characters needed characters left
I've never had problems using Sophos in production systems.
more ▼

answered Nov 16, 2012 at 02:26 PM

frambrose gravatar image

frambrose
30 1 1 1

Most A/V products won't have an issue... if configured to play nicely with SQL Server.
Nov 16, 2012 at 04:03 PM Blackhawk-17
@frambrose - as @blackhawk-17 says, the configuration is the thing. What configurations / exceptions / whatever do you use with the Sophos product?
Nov 16, 2012 at 05:43 PM ThomasRushton ♦
nice great
Feb 20, 2013 at 11:15 AM askmlx121
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1945

asked: Nov 13, 2012 at 02:53 PM

Seen: 1091 times

Last Updated: Feb 20, 2013 at 11:15 AM