Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Friday, May 7, 2004 5:08 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, July 10, 2014 1:34 PM
Points: 6,623, Visits: 1,855
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), SQLServerCentral.com
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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, May 4, 2014 10:21 PM
Points: 202, Visits: 307

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.

Thanks.




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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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