Configuration Database and Transaction Log files: The following files must be excluded from antivirus scanning:
DA version 8.0 and higher also has additional files required for Analytics. If running Compliance Accelerator (CA) and/or Discovery Accelerator (DA), be sure to exclude the Database and Transaction Log files for these products. Special Considerations for the Accelerator Databases The following locations should be excluded from scanning: If running antivirus on a SQL Cluster, be sure to select an antivirus application that is cluster-aware. Special Considerations For SQL Server Clustering These files usually have the following extensions: 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 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. \Program Files\Microsoft SQL Server\MSASX.X\OLAP\Log - Analysis Log files. \Program Files\Microsoft SQL Server\MSASX.X\OLAP\Backup - Analysis backup files. \Program Files\Microsoft SQL Server\MSASX.X\OLAP\Data - Analysis data and temporary files. The default locations for these files on the SQL Server installation drive are: These locations contain the Analysis data files, Analytics temporary files, Analysis Log files and Analysis backup files. Note: If Analysis Services are not configured, the OLAP folder will not be present. (Check each MSSQLX.X folder, there will be multiple FTData folders which need to be excluded from antivirus scanning) 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.
These files contain the backup files and typically have the following extensions: These files contain the data in the Databases and typically have the following extensions: If the SQL installation paths have been customized, be sure to adjust the antivirus exclusion locations accordingly. Important: The locations listed below are based on a default installation of SQL. * For information on the recommended list of antivirus exclusions for Enterprise Vault reference 100017720 Solution 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.
These guidelines apply to both Real-Time and On-Demand antivirus scanning. Overall SQL Server performance may also be improved by implementing the following antivirus exclusions, especially when using Discovery Accelerator Analytics.
#2014 sql server express download issues avast software
Configuring the following antivirus exclusions verifies any files required by SQL are not locked or modified by antivirus software when they are needed. 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.
0 kommentar(er)
