Re: virus scanning SQL 2000 databases

From: Dinesh T.K (tkdinesh_at_nospam.mail.tkdinesh.com)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 06:58:33 +0530

Don,
>>>Am I right?

Yes.The mdf,ldf,ndf and full text catalogs, if any. For more information,
refer:
'INF: Consideration for a Virus Scanner on a Computer That Is Running
SQLServer'
http://support.microsoft.com/default.aspx?id=309422 

--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Don Castiglioni" <don.castiglioni@co.travis.tx.us> wrote in message
news:e51tLV1REHA.2704@TK2MSFTNGP10.phx.gbl...
> I recently upgraded SQL 7 to SQL 2000 .  Thanks to help from people
posting
> on this newsgroup such as Andrew Kelly and Tibor Karaszi my upgrade went
> smoothly.
>
> Now I have a question about excluding certain SQL directories from Virus
> scan read and writes, and from backups.   I think that running a virus
scan
> or backup job against an active database could cause problems. Am I right?
> I use McAfee antivirus and veritas backup exec for tape backups.  I think
I
> should exclude:
> ...\MICROSOFT SQL SERVER\MSSQL\Data
> Are there any other directories or files I should exclude from virus scan
> and backups?
>
>
>
>

Relevant Pages

  • Re: File corruptions in W 97. Professional Writer.Should I buy word 2
    ... People cry 'Virus' when they don't know what the problem ... I have three USB backups and I tried opening the ... The installation completed; however, during ... Later on, the file stopped opening at all, and I got the error message ...
    (microsoft.public.word.docmanagement)
  • Critical SBS ActiveDirectory Problem
    ... using sharepoint (w/ SQL Server), ... deal when you have backups, but this is critical because I do not have ... Perhaps because I was running it in Directory Services Restore ...
    (microsoft.public.windows.server.sbs)
  • Re: Critical SBS ActiveDirectory Problem
    ... using sharepoint (w/ SQL Server), ... deal when you have backups, but this is critical because I do not have ... What will happen to my user mail files? ... Your user mail files are likely to be fine, although you may need to use ...
    (microsoft.public.windows.server.sbs)
  • Re: urgent import/export or backup question
    ... >i am new to this disscusion group, i have long period participations in ... To protect your data you should be using regular backups, ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL 2000 - Databases getting backed up multiple times
    ... SQL Server MVP ... kgboles a earthlink dt net ... There are external applications doing the backups. ...
    (microsoft.public.sqlserver.server)