May 12, 2011 at 10:08 am
Trying to troubleshooting performance issue, and see what is the best practice for setting up anti-virus software.
Is it a common practice for excluding .mdf, .ldf, .ndf files and backup files.
What if backup files get infected, then we no longer can recover databases.
May 12, 2011 at 5:26 pm
Use Transparent Data Encryption to encrypt the backups or a third part tool to encrypt them 🙂
Thank You,
Best Regards,
SQLBuddy
May 12, 2011 at 6:24 pm
How can that help???
May 13, 2011 at 2:44 am
And how do you infect a mdf or ldf file?
It's the standard behavior to ignore .mdf and .ldf files in specific directories, you could also ignore a few other file types if you are using replication (scripts and bcp files) and you might want to ignore other directories if you are using filestream (or keep it in the list but plan for the small performance hit).
May 13, 2011 at 4:49 am
Excluding database files from the anti-virus is common others stuff is to restrict extra processes ,application,access on database files folder to other users and ports with the help of anti-virus and firewall of the OS
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 13, 2011 at 5:48 am
Don't forget to exclude the MSSQL system directories and the target backup location also.
May 13, 2011 at 6:37 am
Also exclude Full-Text catalog files
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply