Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL Antivirus exclusions

Posted on 2013-11-07
1
Medium Priority
?
311 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 2000 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

Cyber Threats to Small Businesses (Part 1)

This past May, Webroot surveyed more than 600 IT decision-makers at medium-sized companies to see how these small businesses perceived new threats facing their organizations.  Read what Webroot CISO, Gary Hayslip, has to say about the survey in part 1 of this 2-part blog series.

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

604 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