[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL and Anti symantec

Posted on 2011-05-03
2
Medium Priority
?
377 Views
Last Modified: 2013-11-22
Can anyone tell me what I can do to make Symantec work good with SQL box.  what needs to be blocked or enabled in SQL so my database will not get corrupted. This is a new SQL windows 2008 standard box.
I just installed Symantec 11.0 V on it and it was not installing due to ACL account  permission.  I had to disbale the account first and than I was able to install the symantec anti virus on the sql box.

now all I need is someone too tell me exactly what I need to disable or enable on the SQL box so my data box does not get corrupted at all.  Is there anything in Symantec Anti virus that I need to disable or on SQl please give me details.

I found this on the internet. :
Now, there are a few configuration changes (in my opinion) that should be made since it is a SQL Server.

 Don’t try and scan the mdf, ndf, or ldf files.  SQL Server has them locked so the anti-virus will just error out when it tries to scan them anyway.  And if the SQL Server is stopped and the anti-virus thinks that it sees a virus in the files, it’ll just corrupt the file when it tries to clean it.
 Make sure that your scans are being done at a time which is appropriate for the load on the SQL Server at that time.  If the scan runs during the day and its an OLTP system, probably not the best idea.  If its an OLAP database then the middle of the night, when the load is running or the early morning when reports are running probably isn’t the best time.
Tell the anti-virus not to do real time scanning of your backup folder (weekly scanning is fine), but this will slow down your backup and restore time.  Make sure that all it does is tell someone if the backup file has a virus, we don’t want it to corrupt the SQL Backup by accident either.
Have other rules that you follow?  Or a conflicting idea?
0
Comment
Question by:syedtaha
2 Comments
 
LVL 30

Accepted Solution

by:
Thomas Zucker-Scharff earned 2000 total points
ID: 35513310
Microsoft recommends NOT scanning databases while they are in use.  I don't run a sql server so I'll stop there.
0
 

Author Comment

by:syedtaha
ID: 35690840
good info
0

Featured Post

 The Evil-ution of Network Security Threats

What are the hacks that forever changed the security industry? To answer that question, we created an exciting new eBook that takes you on a trip through hacking history. It explores the top hacks from the 80s to 2010s, why they mattered, and how the security industry responded.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PREFACE The purpose of this guide is to provide information to successfully add specific IIS 7.0 role services for the Symantec Endpoint Protection Manager (SEPM) to function properly when installed on Windows 2008. AUDIENCE Information Technol…
HOW TO REMOTELY CLEAN MEROND.O WITH ESET SILENTLY PROBLEM       If you have the fortunate luck to contract the Merond.O virus on your network, it can be quite troublesome to remove as it propagates to network shares on your network. In my case, the …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question