Colin Phillips (Alumni)
Much has been blogged about SQL Server 2008 / 2008 R2 Antivirus exceptions when using SharePoint 2010, but no one seems to have blogged the SQL Server 2012 exceptions. That being the case, I figured I might as well be the one to do it. Below you’ll find a list of all the files.
**Important Note** My installation was the BI edition of SQL 2012, as we had no need for (let alone license to) the enterprise edition. As such, we had no particular need for SSAS or SSRS or High Availability (yes, all the BI tools you need for SharePoint 2010, when using SQL 2012, are included in the BI edition without having SSAS or SSRS installed on your SQL box). We followed this up with an install of PowerPivot on the SharePoint 2010 server, which installed many of the SSAS components on that machine, so I am using the paths found on the SharePoint box in my assumptions below. Be sure to set the exclusions on the correct machine (if you have SSAS / SSRS installed on your SQL box for some reason, turn the exclusions on there too).
|
Product |
Description |
Exclusion Type |
Location |
Comments |
|
SQL 2012 |
Data Files |
Extension |
.mdf, .ldf, .ndf |
|
|
Backup Files |
Extension |
.bak, .trn |
||
|
Full-Text Catalog Files |
Folder |
Default instance: Drive:\Program Files\Microsoft SQL Server\MSSQL\FTDATA Or… Named instance: Drive:\Program Files\Microsoft SQL Server\MSSQL$<Instance Name>\FTDATA |
SharePoint 2010 doesn’t require this to be turned on, so we did not enable it. I’m assuming the value is accurate according to my source for this (based on the 2008 value). |
|
|
Trace Files |
Extension |
.trc |
||
| SQL Audit Files | Extension | .sqlaudit | For more info see: MSDN SQLAudit Info | |
| SQL Query Files | Extension | .sql | ||
| SSAS Data and Temp Folder | Folder | Default:Drive:\Program Files\Microsoft SQL Server\MSAS11.<Instance Name>\OLAP\Data |
This could be different and in separate places based on the configuration. ** For PowerPivot with SQL 2012, this will need to be set on your SharePoint machine, not SQL (unless you have SSAS installed on SQL as well) |
|
| SSAS Backup Folder | Folder | Default:Drive:\Program Files\Microsoft SQL Server\MSAS11.<Instance Name>\OLAP\Backup | This could be different based on the configuration.** For PowerPivot with SQL 2012, this will need to be set on your SharePoint machine, not SQL (unless you have SSAS installed on SQL as well) | |
| SSAS Log Folder | Folder | Default:Drive:\Program Files\Microsoft SQL Server\MSAS11.<Instance Name>\OLAP\Log | This could be different based on the configuration.** For PowerPivot with SQL 2012, this will need to be set on your SharePoint machine, not SQL (unless you have SSAS installed on SQL as well) | |
| SSAS additional folders | Folder | Any extra folders added for SSAS in addition to what’s above. |
** For PowerPivot with SQL 2012, these may need to be set on your SharePoint machine |
|
| SQL Server Database Engine | Process | %ProgramFiles%\Microsoft SQL Server\MSSQL11.<Instance Name>\MSSQL\Binn\SQLServr.exe | ||
| SQL Server Reporting Services | Process | %ProgramFiles%\Microsoft SQL Server\MSSQL11.<Instance Name>\Reporting Services\ReportServer\ Bin\ReportingServicesService.exe |
**Assuming 2008 value, with 2012 path. |
|
| SQL Server Analysis Services | Process | %ProgramFiles%\Microsoft SQL Server\MSSQL11.<Instance Name>\OLAP\Bin\MSMDSrv.exe | ||
| SQL High Availability | [UNKNOWN for 2012] | If you’re running antivirus on a SQL cluster, make sure the Antivirus product and version is cluster-aware. |
Note: From what I can tell, these values are not yet officially sanctioned by Microsoft (I can find no reference to these anywhere, but I needed to start somewhere, so I started with the 2008 values and came up with the above values).
Note: The original (SQL Server 2008/R2) source for this is the following blog post: http://spinplate.com/2012/02/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2008-r2/ Many thanks to SpinPlate. Please see the link for the remaining SharePoint 2010 exclusions (including Windows Server exclusions and SharePoint 2010 exclusions).