"Vincent Xu [MSFT]" wrote:

> Hi,
>
> I think one reason other body told you not to install AV on SQL server
> because AV will scan files to protect them from infected. However, you can
> configure it not to scan SQL server related files such as MDF,NDF, LDF,etc.
>
> Briefly, I still suggest you install AV on SQL server to protect the system.
>
> Thanks.
>
>
> Best regards,
>
> Vincent Xu
> Microsoft Online Partner Support
>
> ======================================================
> Get Secure! - www.microsoft.com/security
> ======================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================
> This posting is provided "AS IS" with no warranties,and confers no rights.
> ======================================================
>
>
>
> --------------------
> >>From: "Andrea Montanari" <andrea.sqlDMO@virgilio.it>
> >>Newsgroups: microsoft.public.sqlserver.msde
> >>Subject: Re: Virus Protection
> >>Date: Fri, 16 Jun 2006 03:09:18 +0200
> >>Lines: 26
> >>Message-ID: <4feem4F1ilr4rU1@individual.net>
> >>References: <A23D6D7B-02E7-4985-91EB-7C34C9A06909@microsoft.com>
> >>X-Trace: individual.net iFe7DLioEWAuuW9lAHuvEgqRBMbREknXPLhYXO2x6oo0U5DFMD
> >>X-Priority: 3
> >>X-MSMail-Priority: Normal
> >>X-Newsreader: Microsoft Outlook Express 6.00.3790.2663
> >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2663
> >>X-RFC2646: Format=Flowed; Original
> >>Path:
> TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed.c
> w.net!cw.net!news-FFM2.ecrc.de!fu-berlin.de!uni-berlin.de!individual.net!not
> -for-mail
> >>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.msde:23425
> >>X-Tomcat-NG: microsoft.public.sqlserver.msde
> >>
> >>hi George,
> >>George Schneider wrote:
> >>> I have always been told never install antivirus with a sql server. I
> >>> believe this is because antivirus software might interfere or slow
> >>> down a sql server. IS the same true for MSDE? Can someone explian to
> >>> me why antivirus software on a sql or msde server is a bad idea.
> >>>
> >>
> >>AV do interfere with everything on busy machines :D:D
> >>personally I do install AV in little company servers, as those servers
> are
> >>often used to surf the web as well
> >>:(
> >>
> >>anyway, just not to interfere that much with SQL Server, that does not
> like
> >>database files to be "touched" by anything else but its self, just define
> >>exclusions for "*.Mdf", "*.Ndf" and "*.Ldf" files, which are the "files"
> a
> >>database usually has to be made of...
> >>*.Mdf are the primary data files, *.Ndf are the secondary (if present)
> data
> >>files, while *.Ldf are the transaction log files..
> >>--
> >>Andrea Montanari (Microsoft MVP - SQL Server)
> >>http://www.asql.biz http://italy.mvps.org
> >>DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
> >>--------- remove DMO to reply
> >>
> >>
> >>
>