Solved

SQL Antivirus exclusions

Posted on 2013-11-07
1
279 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

Free book by J.Peter Bruzzese, Microsoft MVP

Are you using Office 365? Trying to set up email signatures but you’re struggling with transport rules and connectors? Let renowned Microsoft MVP J.Peter Bruzzese show you how in this exclusive e-book on Office 365 email signatures. Better yet, it’s free!

Question has a verified solution.

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

Suggested Solutions

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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 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…

911 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

21 Experts available now in Live!

Get 1:1 Help Now