I think your DBA needs to concentrate a little more of the SQL TQL Code, and query plans and queries and a little less on Cluster configuration.
Excluding the quorum and the .MDF, LDF, NDF files should be sufficient, my clusters SQL 2000-2005- and soon 2008 run like champs, besides some craptacular TSQL in some applications and lack of proper DB structure, schema and indexing. Z Edward Ziots Network Engineer Lifespan Organization MCSE,MCSA,MCP+I, ME, CCA, Security +, Network + [email protected] Phone:401-639-3505 ________________________________ From: Steve Kelsay [mailto:[email protected]] Sent: Wednesday, August 12, 2009 3:05 PM To: NT System Admin Issues Subject: RE: Microsoft Cluster and Anti Virus Thanks! I agree with you. I set it up as per the MS Best Practices, but the other people in authority are "experts" on their machines, so I thought I would get some other opinions to back me up. From: Richard Stovall [mailto:[email protected]] Sent: Wednesday, August 12, 2009 2:45 PM To: NT System Admin Issues Subject: RE: Microsoft Cluster and Anti Virus That "quote" from your DBA is not in the MS article - it's from Professional SQL Server 2005 Administration. Just set the proper exclusions for SQL and the cluster (basically the entire quorum drive and the %windir%\cluster folder) and you should be fine. (Test first, obviously...) This is one of those issues that is almost Mac-vs-PC like in terms of the breadth of available opinions and the ferocious conviction with which they are held. From: Steve Kelsay [mailto:[email protected]] Sent: Wednesday, August 12, 2009 2:37 PM To: NT System Admin Issues Subject: Microsoft Cluster and Anti Virus What are you all doing with your cluster servers? I am told Microsoft says "NO!" to antivirus on a clustered machine. Sounds dumb to me. My DBA quoted:"Check to verify that no antivirus software has been installed on the nodes. Antivirus software can reduce the availability of clusters and must not be installed on them." <http://support.microsoft.com/kb/309422> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
