Solved

SQL Antivirus exclusions

Posted on 2013-11-07
1
278 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
Comment Utility
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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...
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now