If anyone knows of a good practice document for setting up policies for SQL servers please link me. Thanks again.
Well i found something telling me to add **\*.filetype so i guess that is covered for filetypes. Still a bit unsure about the processes
Oh now i also see you can add by filetype now under exclusions my bad...
Thanks for your helpful answer..
I had a look at this link: https://kc.mcafee.com/corporate/index?page=content&id=KB67211
is specifys to exclude the following:
\Program Files\Microsoft SQL Server\MSSQL$instancename\DATA\ Data files \Program Files\Microsoft SQL Server\MSSQL$instancename\BACKUP\ Backup files \Program Files\Microsoft SQL Server\MSSQL$instancename\FTDATA\ Full-text catalog files \Program Files\Microsoft SQL Server\MSSQL.X\OLAP\Data\ Folder that holds Analysis Services data Folder holding Analysis Services temporary files used during Analysis Services processing
\Program Files\Microsoft SQL Server\MSSQL.X\OLAP\Backup\
Analysis Services backup files \Program Files\Microsoft SQL Server\MSSQL.X\OLAP\Log\ Folder holding Analysis Services log files
I figured i can do all these with one exclusion: *\program files*\Microsoft SQL Server\
With exclude all sub folders turned on.
I dont really see a need to specify them individually.. when this should cover it off... Is there a need to do them individually?
Message was edited by: nonusedname on 10/07/12 5:02:26 PM
Hi nonusedname, the meaning of excluding folders individually is to avoid excluding more things than needed for security reasons (if you have a virus that copies itself into \program files*\Microsoft SQL Server\ and you have excluded whole folder then you'll be always infected but if you exclude only individual folders you have more chances not to be infected)