Solved

SQL Antivirus exclusions

Posted on 2013-11-07
1
289 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

730 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