What to exclude in Antivirus to work with SQL Server?

 This improves the performance of the files, helps make sure that the files are not locked when the SQL Server service must use them, and avoid possible database corruption.


List of files to exclude from scanning:

SQL Server data files (typical extension is .mdf, .ndf, and .ldf)

SQL Server backup files (typical extension is .bak and .trn)

SQL query files (typical extension is .sql)

Trace files (typical extension is .trc)

Extended Event file targets (Typically saved as .xel or .xem)

Full-Text catalog files (Default instance: Program Files\Microsoft SQL Server\MSSQL\FTDATA, Named instance: Program Files\Microsoft SQL Server\MSSQL$instancename\FTDATA)


List of processes to exclude:

SQLServr .exe

ReportingServicesService .exe

MSMDSrv .exe

SQLDumper.exe


Reference:

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/security/antivirus-and-sql-server

Comments