{"id":288,"date":"2012-06-27T23:55:38","date_gmt":"2012-06-28T06:55:38","guid":{"rendered":"https:\/\/mmman.itgroove.net\/?p=288"},"modified":"2023-02-24T21:47:02","modified_gmt":"2023-02-24T21:47:02","slug":"antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012","status":"publish","type":"post","link":"https:\/\/regroove.ca\/archive\/2012\/06\/27\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012\/","title":{"rendered":"Antivirus Exclusions for SharePoint 2010 and SQL Server 2012"},"content":{"rendered":"

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.\u00a0 That being the case, I figured I might as well be the one to do it.\u00a0 Below you\u2019ll find a list of all the files.<\/p>\n

**Important Note** My installation was the BI edition of SQL 2012, as we had no need for (let alone license to) the enterprise edition.\u00a0 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).\u00a0 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.\u00a0 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).<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

Product<\/p>\n<\/td>\n

\n

Description<\/p>\n<\/td>\n

\n

Exclusion Type<\/p>\n<\/td>\n

\n

Location<\/p>\n<\/td>\n

\n

Comments<\/p>\n<\/td>\n<\/tr>\n

\n

SQL 2012<\/p>\n<\/td>\n

\n

Data Files<\/p>\n<\/td>\n

\n

Extension<\/p>\n<\/td>\n

\n

.mdf, .ldf, .ndf<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
<\/td>\n\n

Backup Files<\/p>\n<\/td>\n

\n

Extension<\/p>\n<\/td>\n

\n

.bak, .trn<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
<\/td>\n\n

Full-Text Catalog Files<\/p>\n<\/td>\n

\n

Folder<\/p>\n<\/td>\n

\n

Default instance:<\/p>\n

Drive:\\Program Files\\Microsoft SQL Server\\MSSQL\\FTDATA<\/p>\n

Or\u2026<\/p>\n

Named instance:<\/p>\n

Drive:\\Program Files\\Microsoft SQL Server\\MSSQL$<Instance Name>\\FTDATA<\/p>\n<\/td>\n

\n

SharePoint 2010 doesn\u2019t require this to be turned on, so we did not enable it.\u00a0 I\u2019m assuming the value is accurate according to my source for this (based on the 2008 value).<\/p>\n<\/td>\n<\/tr>\n

<\/td>\n\n

Trace Files<\/p>\n<\/td>\n

\n

Extension<\/p>\n<\/td>\n

\n

.trc<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
<\/td>\nSQL Audit Files<\/td>\nExtension<\/td>\n.sqlaudit<\/td>\nFor more info see: MSDN SQLAudit Info<\/a><\/td>\n<\/tr>\n
<\/td>\nSQL Query Files<\/td>\nExtension<\/td>\n.sql<\/td>\n<\/td>\n<\/tr>\n
<\/td>\nSSAS Data and Temp Folder<\/td>\nFolder<\/td>\nDefault:Drive:\\Program Files\\Microsoft SQL Server\\MSAS11.<Instance Name>\\OLAP\\Data<\/td>\n\n

This could be different and in separate places based on the configuration.<\/p>\n

** 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)<\/p>\n<\/td>\n<\/tr>\n

<\/td>\nSSAS Backup Folder<\/td>\nFolder<\/td>\nDefault:Drive:\\Program Files\\Microsoft SQL Server\\MSAS11.<Instance Name>\\OLAP\\Backup<\/td>\nThis 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)<\/td>\n<\/tr>\n
<\/td>\nSSAS Log Folder<\/td>\nFolder<\/td>\nDefault:Drive:\\Program Files\\Microsoft SQL Server\\MSAS11.<Instance Name>\\OLAP\\Log<\/td>\nThis 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)<\/td>\n<\/tr>\n
<\/td>\nSSAS additional folders<\/td>\nFolder<\/td>\nAny extra folders added for SSAS in addition to what\u2019s above.<\/td>\n\n

** For PowerPivot with SQL 2012, these may need to be set on your SharePoint machine<\/p>\n<\/td>\n<\/tr>\n

<\/td>\nSQL Server Database Engine<\/td>\nProcess<\/td>\n%ProgramFiles%\\Microsoft SQL Server\\MSSQL11.<Instance Name>\\MSSQL\\Binn\\SQLServr.exe<\/td>\n<\/td>\n<\/tr>\n
<\/td>\nSQL Server Reporting Services<\/td>\nProcess<\/td>\n%ProgramFiles%\\Microsoft SQL Server\\MSSQL11.<Instance Name>\\Reporting Services\\ReportServer\\
\nBin\\ReportingServicesService.exe<\/td>\n		\n

**Assuming 2008 value, with 2012 path.<\/p>\n<\/td>\n<\/tr>\n

<\/td>\nSQL Server Analysis Services<\/td>\nProcess<\/td>\n%ProgramFiles%\\Microsoft SQL Server\\MSSQL11.<Instance Name>\\OLAP\\Bin\\MSMDSrv.exe<\/td>\n<\/td>\n<\/tr>\n
<\/td>\nSQL High Availability<\/td>\n<\/td>\n[UNKNOWN for 2012]<\/td>\nIf you\u2019re running antivirus on a SQL cluster, make sure the Antivirus product and version is cluster-aware.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

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).<\/p>\n

Note: The original (SQL Server 2008\/R2) source for this is the following blog post:\u00a0 http:\/\/spinplate.com\/2012\/02\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2008-r2\/<\/a> Many thanks to SpinPlate.\u00a0 Please see the link for the remaining SharePoint 2010 exclusions (including Windows Server exclusions and SharePoint 2010 exclusions).<\/p>\n","protected":false},"excerpt":{"rendered":"

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.\u00a0 That being the case, I figured I might as well be the one to do it.\u00a0 Below you\u2019ll find a list of all the files. **Important … <\/a><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[24,7,32],"tags":[],"acf":[],"yoast_head":"\nAntivirus Exclusions for SharePoint 2010 and SQL Server 2012 - Archive<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/regroove.ca\/archive\/2012\/06\/27\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Antivirus Exclusions for SharePoint 2010 and SQL Server 2012 - Archive\" \/>\n<meta property=\"og:description\" content=\"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.\u00a0 That being the case, I figured I might as well be the one to do it.\u00a0 Below you\u2019ll find a list of all the files. **Important …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/archive\/2012\/06\/27\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012\/\" \/>\n<meta property=\"og:site_name\" content=\"Archive\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-28T06:55:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-24T21:47:02+00:00\" \/>\n<meta name=\"author\" content=\"Colin Phillips (Alumni)\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Colin Phillips (Alumni)\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/archive\/2012\/06\/27\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012\/\",\"url\":\"https:\/\/regroove.ca\/archive\/2012\/06\/27\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012\/\",\"name\":\"Antivirus Exclusions for SharePoint 2010 and SQL Server 2012 - Archive\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#website\"},\"datePublished\":\"2012-06-28T06:55:38+00:00\",\"dateModified\":\"2023-02-24T21:47:02+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2012\/06\/27\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/archive\/2012\/06\/27\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/archive\/2012\/06\/27\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog Archive\",\"item\":\"https:\/\/regroove.ca\/archive\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Antivirus Exclusions for SharePoint 2010 and SQL Server 2012\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/archive\/#website\",\"url\":\"https:\/\/regroove.ca\/archive\/\",\"name\":\"Archive\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/archive\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\",\"name\":\"Colin Phillips (Alumni)\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"caption\":\"Colin Phillips (Alumni)\"},\"url\":\"https:\/\/regroove.ca\/archive\/author\/cphillips\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Antivirus Exclusions for SharePoint 2010 and SQL Server 2012 - Archive","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/regroove.ca\/archive\/2012\/06\/27\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012\/","og_locale":"en_US","og_type":"article","og_title":"Antivirus Exclusions for SharePoint 2010 and SQL Server 2012 - Archive","og_description":"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.\u00a0 That being the case, I figured I might as well be the one to do it.\u00a0 Below you\u2019ll find a list of all the files. **Important …","og_url":"https:\/\/regroove.ca\/archive\/2012\/06\/27\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012\/","og_site_name":"Archive","article_published_time":"2012-06-28T06:55:38+00:00","article_modified_time":"2023-02-24T21:47:02+00:00","author":"Colin Phillips (Alumni)","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Colin Phillips (Alumni)","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/archive\/2012\/06\/27\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012\/","url":"https:\/\/regroove.ca\/archive\/2012\/06\/27\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012\/","name":"Antivirus Exclusions for SharePoint 2010 and SQL Server 2012 - Archive","isPartOf":{"@id":"https:\/\/regroove.ca\/archive\/#website"},"datePublished":"2012-06-28T06:55:38+00:00","dateModified":"2023-02-24T21:47:02+00:00","author":{"@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/archive\/2012\/06\/27\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/archive\/2012\/06\/27\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/archive\/2012\/06\/27\/antivirus-exclusions-for-sharepoint-2010-and-sql-server-2012\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Archive","item":"https:\/\/regroove.ca\/archive\/"},{"@type":"ListItem","position":2,"name":"Antivirus Exclusions for SharePoint 2010 and SQL Server 2012"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/archive\/#website","url":"https:\/\/regroove.ca\/archive\/","name":"Archive","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/archive\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b","name":"Colin Phillips (Alumni)","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","caption":"Colin Phillips (Alumni)"},"url":"https:\/\/regroove.ca\/archive\/author\/cphillips\/"}]}},"_links":{"self":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/288"}],"collection":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/comments?post=288"}],"version-history":[{"count":1,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/288\/revisions"}],"predecessor-version":[{"id":1987,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/288\/revisions\/1987"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/media?parent=288"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/categories?post=288"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/tags?post=288"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}