September 5, 2003 at 2:56 am
Hi
Recently, my databases went suspect and I eventually had to do full restores. Then a week later it all happend again. It turned out that Norton Anti Virus had been installed on the server and was probably corrupting the db's. Can anyone recommend a SQL server friendly anti-virus solution? Unfortunately the obvious solution of getting Norton to skip SQL Server files is not available to me.
Thanks
CB
September 5, 2003 at 2:59 am
Hi CB,
quote:
Recently, my databases went suspect and I eventually had to do full restores. Then a week later it all happend again. It turned out that Norton Anti Virus had been installed on the server and was probably corrupting the db's. Can anyone recommend a SQL server friendly anti-virus solution? Unfortunately the obvious solution of getting Norton to skip SQL Server files is not available to me.
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=15482 will probably help you.
Personally I excluded, as in the thread mentioned, data files and logs
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
September 5, 2003 at 4:19 am
I agree with Franks choice as most look in realtime at what is being accessed so by excluding those that are accessed all the time it should be a non-issue on impact. We run AntiVirus on most all the corporate servers but I have yet to place on ours (but I do keep my patches current and don't let them talk to shifty computers as much as possible and I have the SQL Server behind the Web Server as far as most contact is concerned).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply