Hello All,

If I have a server that is ONLY running SQL Server 2005. What are the
pros/cons to running Norton Antivirus on that server?

Does it make sense or is it a waste of resources?

thanks..

"MSUTech" <MSUTech@discussions.microsoft.com> wrote in message
news:56FA43A5-F6A1-4200-9CD0-A7E5190EAB4E@microsoft.com...
> Hello All,
>
> If I have a server that is ONLY running SQL Server 2005. What are the
> pros/cons to running Norton Antivirus on that server?
>
> Does it make sense or is it a waste of resources?
>
> thanks..

Some shops require AV on servers as a matter of policy. Just make sure you
exclude database, log and backup files from the scans.

--
David Portas

Having an antivirus on the system is always advisable.However an antivirus
will always use some system resources no matter how much efficient it is.

Ideally it should run fine independent of SQL server service but to put
things in a safer perspective you can exclude the entire SQL directory from
the search.However if by any chance the machine is infected with a virus
then it may as well corrupt the files excluded.

Subhen Kar
MCITP-DBA
Microsoft
--------------------
| >|>|Thread-Topic: Antivirus software on SQL Server computer?
| >|>|thread-index: AckN+evsaeaDa0S1Trq4Ed1nrocDQA==
| >|>|X-WBNR-Posting-Host: 65.55.10.14
| >|>|From: =?Utf-8?B?TVNVVGVjaA==?= <MSUTech@discussions.microsoft.com>
| >|>|Subject: Antivirus software on SQL Server computer?
| >|>|Date: Wed, 3 Sep 2008 12:19:01 -0700
| >|>|Lines: 8
| >|>|Message-ID: <56FA43A5-F6A1-4200-9CD0-A7E5190EAB4E@microsoft.com>
| >|>|MIME-Version: 1.0
| >|>|Content-Type: text/plain;
| >|>| charset="Utf-8"
| >|>|Content-Transfer-Encoding: 7bit
| >|>|X-Newsreader: Microsoft CDO for Windows 2000
| >|>|Content-Class: urn:content-classes:message
| >|>|Importance: normal
| >|>|Priority: normal
| >|>|X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.3119
| >|>|Newsgroups: microsoft.public.sqlserver.server
| >|>|Path: TK2MSFTNGHUB02.phx.gbl
| >|>|Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:48368
| >|>|NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| >|>|X-Tomcat-NG: microsoft.public.sqlserver.server
| >|>|
| >|>|Hello All,
| >|>|
| >|>|If I have a server that is ONLY running SQL Server 2005. What are
the
| >|>|pros/cons to running Norton Antivirus on that server?
| >|>|
| >|>|Does it make sense or is it a waste of resources?
| >|>|
| >|>|thanks..
| >|>|

"MSUTech" <MSUTech@discussions.microsoft.com> wrote in message
news:56FA43A5-F6A1-4200-9CD0-A7E5190EAB4E@microsoft.com...
> Hello All,
>
> If I have a server that is ONLY running SQL Server 2005. What are the
> pros/cons to running Norton Antivirus on that server?
>
> Does it make sense or is it a waste of resources?
>
> thanks..

Have you seen

http://www.thepcspy.com/read/what_re...windows_down/5

and

http://support.microsoft.com/kb/309422/en-us

John