This content has been marked as final. Show 5 replies
where are all of the McAfee experts out there? LOL
I expect everyone's on holiday. Just back at work today myself. :O]
I just exclude the Data and Log directories. I experienced no large performance hit (set up a performance log for before and after) and I haven't noticed it corrupting any databases.
Thanks for the reply. Do you find it hard to do that when you have 10 different departments that have SQL servers and they save the data in different directories/volumes?
Just curious on how you handle that.
I don't have that problem. :O]
I imagine I would either just set all the exclusions as required or, if I could trust them, allow local exclusions.
Regarding the exclusion, you can study the following - howto from mcafee
and the SQL one -
I'm using exclusions **\mssql\data and **\mssql\backup
Also excluded files older than 30 days not to be scan on read.
Remember to add exclusions to both On-Access scan and On-Demand scan
The optimal setting would be that you exlcude **\mssql\*.MDF +the other extension.
The more accurate the more secure. With my exclusion, you could place any file under **\mssql\backup and it will not be scanned.