Solved

SQL Antivirus exclusions

Posted on 2013-11-07
1
283 Views
Last Modified: 2016-02-25
Hello,

Does anyone have a good document on what I should exclude from my AV scanning for sql?  I have two servers that each have a db on them.  Nothing fancy..I just don't want the AV (Sophos) to lock any files.

Thanks,
0
Comment
Question by:soadmin
1 Comment
 
LVL 10

Accepted Solution

by:
PadawanDBA earned 500 total points
ID: 39631436
I would exclude the mdf, ldf, and ndf file extensions.  And also .bak/.trn.  That will prevent scanning the db datafiles and also the backups/transaction log backups.  If you want, you could also exclude the folders where the SQL Server binaries were installed too (Defaults for an x64 install are Program Files\Microsoft SQL Server and Program Files (x86)\Microsoft SQL Server).  Hope that helps!
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question