Re: SQL Server 2k and Anti-virus on the server

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 03/22/04

  • Next message: Tibor Karaszi: "Re: out of control T-Log? NEED HELP PLEASE..." 
    Date: Mon, 22 Mar 2004 21:57:45 -0000

    We run AV on all SQL Servers, like you say avoid the actual database files
    and full text catalogs (if use FT) you should be fine. There is only really
    this KB article which doesn't say much :-)

    INF: Consideration for a Virus Scanner on a Computer That Is Running SQL
    Server
    http://support.microsoft.com/default.aspx?scid=kb;en-us;q309422 

    -- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Chris" <da_13ear@hotmail.com> wrote in message
news:7deda489.0403221124.5cb5b9d7@posting.google.com...
> Dear SQL gurus:
>      I know i may be asking a question that is taboo, but what the
> heck.  I am building a new SQL2k dev box, but would like to install AV
> on it, as it wont be isolated with only 1433 open to it from the
> client-base.  Now, i did a ton or research on Symantec, Trend-Micro
> and MS's sites and i couldn't find anything definitive regarding this.
>  Does anyone have any best practices?  Also, i dont understand why
> loading AV would be such an issue (outside of the performance hit) if
> you ensured that you didn't do real-time on SQL-specific files /
> folders?  Thanks for any and all responses to my inquiry.  Hope i
> livened up someone's day.
>
> -CS
  • Next message: Tibor Karaszi: "Re: out of control T-Log? NEED HELP PLEASE..."

    Relevant Pages

    • RE: SQL Server 2005 SP1 install fails on Windows 2003 EE R2, need DB mirroring
      ... You encountered the error when you installed the SQL Server 2005 SP1. ... This issue seems most likely caused by the master database files locating ... You can use a tool, such as Sysinternals Process Explorer, to ... determine the location of the master and Resource database files that are ...
      (microsoft.public.sqlserver.setup)
    • Re: Maintenance Plan
      ... SQL Server doesn't grow the database files by itself. ... >> Tibor Karaszi, SQL Server MVP ...
      (microsoft.public.sqlserver.server)
    • Re: Save as in SQL Server(Backup - Restore)
      ... Tibor Karaszi, SQL Server MVP ... >> Tibor Karaszi, SQL Server MVP ... >>> device not supported for database files. ...
      (microsoft.public.sqlserver.programming)
    • Re: Database normalization
      ... > My problem is that I have around 150+ database files in DBF format. ... Assuming "DBF format" means xBase/FoxPro format data not in SQL Server ...
      (comp.databases.ms-sqlserver)
    • Re: Recommended Approach for deploying SQL Server Express with shrink wrap software
      ... In my current Jet application, I perform an auto-backup whenever some exits ... that I don't provide install SQL Server Express with external TCP/IP access ... I used to trust my users to backup their database files. ...
      (microsoft.public.sqlserver.msde)