 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Clustering / June 2006How do you configure Symantec AntiVirus on a Microsoft SQL Server that is in a two-node cluster?
Gurus, How do you all configure Symantec AntiVirus on a Microsoft SQL Server that is in a two-node cluster? Do you install the antivirus on both physical nodes and exclude the MDF and LDF files from real-time scanning? And that's it?  SignatureSpin You do not install Anti-virus at all on a clustered installation. The AV drivers tend to work poorly with the clustered disk resource drivers, sometimes preventing a resource failover. SignatureGeoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP > Gurus, > > How do you all configure Symantec AntiVirus on a Microsoft SQL Server that > is in a two-node cluster? Do you install the antivirus on both physical > nodes and exclude the MDF and LDF files from real-time scanning? And > that's it? What, then do you do for AV protection?? It's insanity to have a server running w/o AV protection.... Regards, Hank Arnold > You do not install Anti-virus at all on a clustered installation. The AV > drivers tend to work poorly with the clustered disk resource drivers, > sometimes preventing a resource failover. As Geoff said, AV drivers have a real potential of causing nasty problems that may be difficult to reproduce. However, in an enterprise, corporate security often trumps any DBA concerns, and completely getting rid of running AV is not a possibility. We end up exlcuding any mdf, ndf, ldf, bak, and trn files. Linchi > What, then do you do for AV protection?? It's insanity to have a server > running w/o AV protection.... [quoted text clipped - 5 lines] > > drivers tend to work poorly with the clustered disk resource drivers, > > sometimes preventing a resource failover. Why .bak and .trn and files? SignatureSpin > As Geoff said, AV drivers have a real potential of causing nasty problems > that may be difficult to reproduce. However, in an enterprise, corporate [quoted text clipped - 16 lines] >> > drivers tend to work poorly with the clustered disk resource drivers, >> > sometimes preventing a resource failover. Typically, these are SQL backup files in our environment. You can of course backup databases/logs to files of any file extensions you may choose. Virus scanning these files can cause the backup jobs to fail when the SQL instance tries to backup to a file that is being virus scanned, thus can't get hold of the file. Linchi > Why .bak and .trn and files? > [quoted text clipped - 18 lines] > >> > drivers tend to work poorly with the clustered disk resource drivers, > >> > sometimes preventing a resource failover. We use it, exclude the MSCS directory and any data/DB directories. Cheers, Rodney R. Fournier MVP - Windows Server - Clustering http://www.nw-america.com - Clustering Website http://msmvps.com/clustering - Blog http://www.clusterhelp.com - Cluster Training ClusterHelp.com is a Microsoft Certified Gold Partner > Gurus, > > How do you all configure Symantec AntiVirus on a Microsoft SQL Server that > is in a two-node cluster? Do you install the antivirus on both physical > nodes and exclude the MDF and LDF files from real-time scanning? And > that's it? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.