DBA > Job Interview Questions > Microsoft SQL Server FAQs

You have a SQL Server 2005 cluster and need to a

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

You have a SQL Server 2005 cluster and need to add anti-virus software as per your corporate standards. What should you exclude from scans?

Answer
Log and data files for your databases as well as the Quorum drive and the backup folders.

Explanation
Anti-virus programs can exist on the same server as SQL Server without an issue if you exclude certain items. The database data and log files, backup files and folders, the quorum drive for clusters, temporary replication files, the SQL Server log files, and Log Shipping folders/files. You do not need to exclude that SQL Server executables and probably do not want to so that they are protected.

(Continued on next question...)

Other Job Interview Questions