February 25, 2003 at 1:30 pm
My apologies if this subject has been addressed in the past. What is the recommendation for running VirusScan and SQL Server on the same machine? Is there a negative impact to performance and if so, how much of a negative impact?
February 25, 2003 at 4:21 pm
It can if you have it set to scan all files. Make sure MDF, NDF, LDF are on the exceptions list and you shouldn't see much impact if any.
May 8, 2003 at 5:29 am
What is the general approach to address the virus detection issue on SQL server. Are there any standard tools to prevent SQL server from being infected? And are there any viruses affecting the files with those extensions mentioned in the posting before?
Edited by - msia3000 on 05/08/2003 05:41:11 AM
May 15, 2003 at 5:43 pm
The MDF, NDF, and LDF extensions Antares686 refers to are the data and log files that SQL Server uses. Since they are not executable, a virus cannot use them to replicate itself. That does not prevent a virus from corrupting or deleting them under some circumstances.
I agree with Antares686 that the MDF, NDF, and LDF extensions should be included in the exceptions list for both the scheduled scan jobs, as well as the agent job for "on access".
David R Buckingham, MCDBA,MCSA,MCP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply