Problem The purpose of this document is to provide a list of recommended antivirus exclusions for SQL Server in order to maintain Enterprise Vault, Compliance Accelerator and Discovery Accelerator data integrity. Configuring the following antivirus exclusions verifies any files required by SQL are not locked or modified by antivirus software when they are needed. Overall SQL Server performance may also be improved by implementing the following antivirus exclusions, especially when using Discovery Accelerator Analytics.

These guidelines apply to both Real-Time and On-Demand antivirus scanning. It is important to reach a balance between a secure server antivirus configuration that does not cause reliability issues and performance degradation; therefore, it is highly recommended that any SQL Server antivirus exclusions be tested in a test environment while subjected to the maximum load expected in a production environment. * For information on the recommended list of antivirus exclusions for Enterprise Vault reference Solution Important: The locations listed below are based on a default installation of SQL.

Addressing Threats to Your Core Infrastructure for Lync Server 2010 Specifying Antivirus Scanning Exclusions. SQL Server processes. Recommended exclusions for Endpoint Security/VirusScan Enterprise. List of exclusions needed for Microsoft SQL.

If the SQL installation paths have been customized, be sure to adjust the antivirus exclusion locations accordingly. SQL Server Data Files These files contain the data in the Databases and typically have the following extensions:.mdf - Primary Data filegroups..ndf - Secondary Data filegroups..ldf - Transaction Log filegroups. SQL Server Backup Files These files contain the backup files and typically have the following extensions:.bak - Database backup files..trn - Transaction Log backup files. Full-Text Catalog Files This is the FTData folder in the SQL Server installation path, located by default at Program Files Microsoft SQL Server MSSQLX.X MSSQL FTData on the SQL Server installation drive. Waze For Pc. (Check each MSSQLX.X folder, there will be multiple FTData folders which need to be excluded from antivirus scanning) Analysis Services Data Note: If Analysis Services are not configured, the OLAP folder will not be present.

These locations contain the Analysis data files, Analytics temporary files, Analysis Log files and Analysis backup files. Midtown Madness 2 Car Pack on this page. The default locations for these files on the SQL Server installation drive are: Program Files Microsoft SQL Server MSASX.X OLAP Data - Analysis data and temporary files. Program Files Microsoft SQL Server MSASX.X OLAP Backup - Analysis backup files. Program Files Microsoft SQL Server MSASX.X OLAP Log - Analysis Log files. SQL Profiler Trace Files These files contain any SQL Profiler Trace log files and can be contained in any folder as specified by a user when running a SQL Profiler Trace. These files usually have the following extensions:.trc Extended Events files These files contain any Extended Events Trace log files and can be contained in any folder as specified by a user when running an Extended Events Trace. These files usually have the following extensions:.xel Special Considerations For SQL Server Clustering If running antivirus on a SQL Cluster, be sure to select an antivirus application that is cluster-aware.

The following locations should be excluded from scanning: - Q: (the Quorum drive). - C: Windows Cluster. Special Considerations for the Accelerator Databases If running Compliance Accelerator (CA) and/or Discovery Accelerator (DA), be sure to exclude the Database and Transaction Log files for these products. DA version 8.0 and higher also has additional files required for Analytics.