Published: December, 2013
Summary: Use this content roadmap to learn how to back and recover PowerPivot for SharePoint, for a single or multi-server environment.
Applies to: SQL Server 2014 PowerPivot for SharePoint 2013 and SharePoint 2013
PowerPivot Configuration Tools
Plan for backup and recovery in SharePoint 2013
Back up farms in SharePoint 2013
Restore farms in SharePoint 2013
Configure backup and restore permissions in SharePoint 2013
Back up the server farm using either Windows PowerShell or the SharePoint Central Administration website. Be sure to include the PowerPivot Service Application database as part of the backup. Back up farms in SharePoint 2013 A PowerPivot service application is a shared service instance of the PowerPivot System Service. Each service application has its own application identity, configuration settings, properties, and internal data storage. Backing up the farm backs up service applications, as well as the configuration and the Central Administration content databases, User Profile service application, customizations, search service application, site collection, and applications for SharePoint.
Back up the server farm using either Windows PowerShell or the SharePoint Central Administration website. Be sure to include the PowerPivot Service Application database as part of the backup.
A PowerPivot service application is a shared service instance of the PowerPivot System Service. Each service application has its own application identity, configuration settings, properties, and internal data storage.
Backing up the farm backs up service applications, as well as the configuration and the Central Administration content databases, User Profile service application, customizations, search service application, site collection, and applications for SharePoint.
NOTE: If you have a single-server environment, all of the products referred to in the following steps will be installed on that machine.
You can install Analysis Services in Multidimensional mode. This provides support for OLAP databases and data mining models. For more information, see Install Analysis Services in Multidimensional and Data Mining Mode.
You can install Analysis Services in the server mode called Tabular. This enables you to use tabular modeling features. You can use the server to host solutions that you build in tabular model designer. For more information, see Install Analysis Services in Tabular Mode.
To use the PowerPivot feature for SharePoint, you need to install at least one Analysis Services server in SharePoint mode. For more information, see Install Analysis Services Server in SharePoint Mode for SharePoint 2013 (SharePoint 2013).
NOTE: If you have a single-server environment, skip Step 3 because this task is covered in Step 1.
PowerPivot for SharePoint is a collection of middle-tier and backend services that provide PowerPivot data access in a SharePoint 2013 farm. The PowerPivot for SharePoint add-in (spPowerpivot.msi) is an installer package used to install the middle-tier components.
Restore the server farm using either Windows PowerShell or the SharePoint Central Administration website.
Restore service applications in SharePoint 2013
See the "Power Pivot Service database" section of Supported high availability and disaster recovery options for SharePoint databases (SharePoint 2013)
Planning for Disaster Recovery for PowerPivot Mid-Tier Server Plan for disaster recovery (SharePoint Server 2010) Plan for disaster recovery (SharePoint Foundation 2010)
Thank you Matthew and Craig for the changes (improvements) you've made to this article.