Re: SQL and Anti-virus

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jacco Schalkwijk (NOSPAMjaccos_at_eurostop.co.uk)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 11:10:29 -0000

Definitly exclude the database files (both data and log files) and I would
also exclude the database and transaction log backups and the SQL Server
error logs (in Program Files\Microsoft SQL Server\MSSQL\Log). If you use
Full Text indexing or replication you should exclude the FTDATA and REPLDATA
directories as well, at least if you want some decent performance. 

-- 
Jacco Schalkwijk
SQL Server MVP
"Jeff Brooks-Manas" <me@here.com> wrote in message
news:ec9ipx9AEHA.2768@tk2msftngp13.phx.gbl...
> Hello,
>
> I'm trying to find out if it's OK to scan a SQL 2000 server with Symantec
> Anti-virus. Symantec's site says not to scan the database files. I've
> excluded the databases, but do I need to exclude anything else? Backup
> databases? Others?
>
> There is detailed information on MSFT's support site, and Symantec's
> regarding Anti-virus and Exchange, but I couldn't find much for SQL,
besides
> that one, pretty general article.
>
> Thanks!
>
> Jeff
>
>

Relevant Pages

  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL and Anti-virus
    ... Definitly exclude the database files and I would ... also exclude the database and transaction log backups and the SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)