Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Seems like a waste of resources to me, but our team is currently discussing. What is generally considered the best practice here?


migration rejected from Feb 18 '15 at 1:00

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as primarily opinion-based by HopelessN00b Feb 18 '15 at 0:59

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise.If this question can be reworded to fit the rules in the help center, please edit the question.

Not related to programming. Voted for migration to Server Fault. – rightfold Oct 22 '11 at 21:47
up vote 14 down vote accepted

Please see Guidelines for choosing antivirus software to run on the computers that are running SQL Server for help.

locked by Community Feb 18 '15 at 0:59
Whilst this may theoretically answer the question, it would be preferable to include the essential parts of the answer here, and provide the link for reference. – Mark Henderson Jan 23 '13 at 20:26

Obviously some machines need AV but if you need help explaining why some machines might not, here's my favorite XKCD comic...

alt tex

locked by Community Feb 18 '15 at 0:59

Is it exposed to the internet? Can the system run processes that start executables?

Typically virus scanning systems are something you want on all systems. Worms that can go from PC-to-PC over the network can still attack systems that are not normally exposed to the internet are one of the common justifications for this.

edit another important part is who as Remote Desktop access? These are poential risk points as well if they go out to the internet for anything. Granted you would hope they would know better, but it is still a potential concern

locked by Community Feb 18 '15 at 0:59