Re: SQL2000 Cluster and virus software

Then as the KB article explains, make sure you exclude the appropriate files
and best of luck. But then again, having AV on every machine does not
necessarily mean running all components. You could run the Virus Sweep
routinely, excluding the appropriate files, but leave the Active Scanning
filter driver off in situations like you describe.

Sincerely,


Anthony Thomas


--

"Rodney R. Fournier [MVP]" <rod@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:ehsIXRYvFHA.3256@xxxxxxxxxxxxxxxxxxxxxxx
I hear you, I really do, its just that some places are required to have AV
on every machine.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training


"Anthony Thomas" <ALThomas@xxxxxxxxx> wrote in message
news:%23YQiu9XvFHA.1168@xxxxxxxxxxxxxxxxxxxxxxx
> Microsoft also recommends that you analyze the threat of a particular
> installation. For most DBMS installations, the server should reside in a
> secured environment with no file shares. Properly locked down, the system
> would be at low risk for virus attacks. As a filter driver, there is a
> performance penalty by having what is known as Active Scanning running on
> the system.
>
> Although Microsoft does not come right out and say it, it does discourage
> AV
> on a dedicated and secured DBMS installation. We have worked with our
> server administrators in conjuction with the AV vendor to properly secure
> such installations and leave this sort of technology on more vunerable
> systems like file servers and communication components.
>
> INF: Consideration for a virus scanner on a computer that is running SQL
> Server 2000
> http://support.microsoft.com/default.aspx?scid=kb;en-us;309422
>
> Sincerely,
>
>
> Anthony Thomas
>
>
>
> --
>
> "Rodney R. Fournier [MVP]" <rod@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:%23xW5NuXvFHA.3080@xxxxxxxxxxxxxxxxxxxxxxx
> You should able to use antivirus software, just exclude the MSCS, MSDTC,
> and
> SQL data directories.
>
> Cheers,
>
> Rod
>
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
>
>
> "MichaelW" <MichaelW@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:E135F5B1-0A0D-4EDA-9BAC-F691491FA3CE@xxxxxxxxxxxxxxxx
>> Microsoftâ??s SQL Server 2000 Failover Clustering doc states the
>> following
>> under miscellaneous configuration issues:
>>
>> â??Disable or do not install antivirus software on your clusterâ?? and
>> then
>> gives a link to that KB article.
>>
>> The KB article explains this as the reason why you might disable it:
>>
>> Most antivirus software uses filter drivers (device drivers) that work in
>> conjunction with a service to scan for viruses. These filter drivers
>> reside
>> above the file system recognizer and scan files as they are opened and
>> closed
>> on a local hard disk. Antivirus software may not understand the shared
>> disk
>> model and may not properly allow for failover.
>>
>> The KB also says this:
>>
>> Warning This workaround may make your computer or your network more
>> vulnerable to attack by malicious users or by malicious software such as
>> viruses. We do not recommend this workaround but are providing this
>> information so that you can implement this workaround at your own
>> discretion.
>> Use this workaround at your own risk.
>>
>>
>> So does Microsoft recommend using virus software or not, they did both in
>> the clustering doc / KB.
>>
>> Thanks!
>
>


.

Relevant Pages

  • Re: SQL2000 Cluster and virus software
    ... on a dedicated and secured DBMS installation. ... server administrators in conjuction with the AV vendor to properly secure ... MVP - Windows Server - Clustering ... > â??Disable or do not install antivirus software on your clusterâ?? ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL2000 Cluster and virus software
    ... MVP - Windows Server - Clustering ... > You should able to use antivirus software, just exclude the MSCS, MSDTC, ... We do not recommend this workaround but are providing this ...
    (microsoft.public.sqlserver.clustering)
  • HA & Failover options
    ... instances for all the technology components (App Server, DB Server, ... Application Server 10g Release 3 and Oracle Database Release 2. ... Clustering features. ... how instantaneous is failover to the secondary site with data ...
    (comp.databases.oracle.server)
  • Re: Replication with failover clustering??
    ... We are having Merge Replication setup with push subscription. ... Microsoft SQL Server clustering is not a good fit for geospatial clustering ... Both clustering and database mirroring do do automatic failover, ...
    (microsoft.public.sqlserver.replication)
  • Re: Choosing correct high availability setup
    ... won't be supported/allowed with Windows Server 2008 Failover Clustering. ... No matter how you do your SQL, IIS will need to know the instance name to ...
    (microsoft.public.sqlserver.clustering)
Loading