Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Server Security: Dealing with Anti-Virus Programs Expand / Collapse
Posted Friday, May 7, 2004 5:08 PM

Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, September 16, 2016 11:44 AM
Points: 6,639, Visits: 1,905
Comments posted to this topic are about the content posted at http://www.sqlservercentral.c

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security),
Author of
Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #115032
Posted Thursday, May 13, 2004 7:29 AM


Group: General Forum Members
Last Login: Thursday, March 12, 2015 2:42 PM
Points: 199, Visits: 310

Good article Brian!

One thing I would like to add.  Backing up SQL Server databases using a perl script (or any other type of OS scripting language script) is a very good idea.  It allows you to very easily enforce backup and restore standards and methodologies.

Although you could conceivably perform all the operations you need to do using T-SQL and xp_cmdshell, I find Perl gives greater flexibility and ease of maintenance.

If you are performing your backups uniformly using an OS shell script, it is very easy to configure security and virus scanning for the file system for all of the SQL Servers you may be managing.

Post #115794
Posted Thursday, May 13, 2004 7:34 AM

Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 27, 2010 7:51 PM
Points: 1,244, Visits: 3

An excellent article that meets its stated goal.  The explanations are well stated and allow for other points of view and discussion.

I especially appreciate the pointers to the knowledge base articles, and other web sites. that allow me to further research and convince others of the risks and benefits.  In other articles, especially other web sites, these links are often times missing, which may leave unanswered questions.


Post #115798
Posted Thursday, May 13, 2004 8:47 AM


Group: General Forum Members
Last Login: Friday, May 4, 2012 4:28 PM
Points: 15, Visits: 40

Your article was very clear and concise.  I have Symantec AV client running on my SQL Servers, and the reason I excluded the database files was the possibility that the AV software might quarantine one of them!  I had that problem initially with Exchange log files on another server until I sorted it out.

Thanks for the article.

Post #115825
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse