SQL Server – Antivirus – Exception Configuration – McAfee

Background

A quick word on configuring McAfee AV for use on a Microsoft SQL Server system.

 

Steps

  1. Launch McAfee On-Access Scan
  2. The “On-Access Scan Properties” window appears
  3. From the left panel, click on the “All processes” icon (  AllProcesses )
  4. Click the “Exclusions” tab
  5. In the Exclusions tab, click the “Exclusions” button ( Exclusions )
  6. The “Set Exclusions” window appear
  7. Click the “Add button” ( AddButton   )
  8. The “Add Exclusion Item” window
  9. Click the “By file type (can include the ? wildcard ) option button
  10. Enter the standard file type/extension for Microsoft SQL Server files; which is mdf
  11. Click the OK button
  12. The “Add Exclusion Item” window closes, and we are returned to the “Set Exclusions” window
  13. Repeat by clicking the “Add button” to add other SQL Server files
    • LDF ( Log file)
    • NDF (Secondary data file )
    • BAK ( Database Backup )
    • LOG/TRN ( Database Transaction Backup )

 

Screen Shots

Set Exclusions – Pre

SetExclusions

Set Exclusions – Post

SetExclusions-Post

 

Code

Here is a short code snippet to identify file extensions in use on a SQL Server Instance


select 

          fileext = right(tblSAF.filename, 3)
	, [numberofFiles] = count(*)

from   master.dbo.sysaltfiles tblSAF

group by

	right(tblSAF.filename, 3)

References

  1. Recommended exclusions for VirusScan Enterprise on Microsoft SQL Servers
    https://kc.mcafee.com/corporate/index?page=content&id=KB67211

 

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s