July 15, 2016 at 1:14 pm
Hello All,
We have received a request from customer that disbaled the antivirus from Database cluster server(Active\passive).
Could you please Confirm if the antivirus software locks a SQL Server files.?
I have serached Few blogs,found below articles(Pinal dave),
Should i suggest the customer to excluded from all antivirus scans as mentioned pinal dave.
I hope you will be able to provide the information.
SQL server DBA
July 15, 2016 at 1:20 pm
Googling for sql server antivirus exclusions, the top two results are a Microsoft support page and an msdn blog page. I refer all of my clients to those two pages.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 15, 2016 at 1:26 pm
Thank you for quick response.
Can you please provide MSDN links here?
Do you want me to suggest the customer to the following files be excluded from all antivirus scans:
SQL Server data files (typical extension is .mdf, .ndf, and .ldf)
SQL Server backup files (typical extension is .bak and .trn)
Full-text catalog files
Trace files (typical extension is .trc)
SQL Audit files
SQL query files (typical extension is .sql)
Directories holding Analysis Services data and partitions
The directory that holds Analysis Services temporary files used during processing
Analysis Services backup files
------
SQLServr .exe
ReportingServicesService .exe
MSMDSrv .exe
Please suggest...
SQL server DBA
July 15, 2016 at 1:57 pm
Database admin(DBA) (7/15/2016)
Thank you for quick response.Can you please provide MSDN links here?
Do you want me to suggest the customer to the following files be excluded from all antivirus scans:
Please suggest...
No, I don't teach people on this forum how to use Google. 🙂
I suggested already that you follow the advice in those two Microsoft links.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply