![]() ![]() In addition to excluding SQL Server and Analysis Services files, it is recommended to exclude the following list of processes from antivirus scans:įor environments where SQL Server is clustered, exclude the C:\Windows\Cluster directory and the Quorum drive. The directory that holds Analysis Services temporary files used during processing.Directories holding Analysis Services data and partitions.SQL query files (typical extension is.SQL Server backup files (typical extension is.SQL Server data files (typical extension is.Therefore, it is recommended that the following files be excluded from all antivirus scans: As you can see there are a number of these random errors one might get because of not implementing a simple best practice. In a number of cases I have seen SQL Server refusing to start sometimes or the CPU / IO seems to be stalling sometimes. #Hpw to run cylance antivirus search software#After rebooting a server, if the antivirus software locks a SQL Server file before SQL Server can gain access to that file, potential issues ranging from SQL Server not being able access those particular files to possible database corruption may occur. There are not many blogs that call them out explicitly.Īlthough antivirus software is a very important part of security planning, it is important to understand the effect it has on SQL Server files. We all know this statements and often I see DBAs not adding any extra care to this recommendation. One of the classics as far as best practices is concerned is to exclude SQL Server files and folders on your antivirus programs running on the server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |