Hi 

I am using Backup-SPFarm PowerShell cmdlet to take a backup of my service applications.

I am able to take the backup of all my services applications except PowerPivot Service Application.

Below is my command:


Backup-SPFarm -Directory $backupSAFolder -BackupMethod Full -Item "Farm\Shared Services\Shared Services Applications\SQL Server PowerPivot Service Application"

Error:  Item Farm\Shared Services\Shared Services Applications\SQL Server PowerPivot Service Application not found. 

I also cross checked with the correct Application service name (to check if i am not doing any typo mistake) using 

Get-SPServiceApplication cmdlet. see the screenshot below.

Could somebody help me p

Hope powerpivot WSP is installed

http://social.technet.microsoft.com/Forums/en-US/0213063c-d473-44a5-8033-ec8e73179f6d/sql-2012-powerpivot-sharepoint-2010-services-missing-sql-server-powerpivot-system-service-sql?forum=sharepointgeneralprevious

the issue which was being caused by the footprint of SQL 2008 R2 remaining on the file system despite it being removed. Removing SQL 2008 R2 from add/remove programs, left a number of files behind, and it this file which appears to have caused the problem: \Program Files\Microsoft SQL Server\MSAS11.PowerPivot

Deleting this, restarting the server, then running through the install again, fixed the problem for me.

Hi Inderjeet,

Thanks for your reply but I am talking about Not able to take a backup of PowerPivot Service Application using Backup-SPFarm.

I have a SP 2013 farm in which I have 2 App Server,  2 WFE and a dedicated SQL server.

Regards,

Yo

You just need to take backup of service application databases from SQL server

http://msdn.microsoft.com/en-us/library/jj218793.aspx

op

2) Backup, Copy, Restore the Databases

The SharePoint database-attach upgrade process is a sequence of steps to back up, copy, and restore PowerPivot related content and service application databases to the SharePoint 2013 farm.

1. Set Database to read-only: In SQL Server Management Studio, right-click the database name and click Properties. On the Options page, set the Database read-Only property to True.

2. Back up: Back up each content database and service application database that you want to migrate to the SharePoint 2013 farm. In SQL Server Management Studio, right-click the database name, click Tasks, and click Back up.

3. File copy the database backup files (.bak) to the desired destination server.

4. Restore: Restore the databases to the destination SQL Server Database Engine. This step can be completed using SQL Server Management Studio.

5. Set Database to read-write: Set the Database read-Only to False.

Migrate Schedules option1: SharePoint farm administrator

1. In the SharePoint 2013 Management Run the Set-PowerPivotServiceApplication cmdlet with the -StartMigratingRefreshSchedules switch to enable automatic on demand schedule migration . The following Windows PowerShell script assumes that there is only one PowerPivot service application.

   $app=Get-PowerPivotServiceApplication
   Set-PowerPivotServiceApplication $app -StartMigratingRefreshSchedules
   

   After the Windows PowerShell script is run, the schedules are active and the schedules will run at the next appropriate time. However, the status one the schedule refresh page is not enabled. When the schedule runs the first time it will be migrated and on the schedule refresh page, Enabled will be true.

2. If you want to check the current value of the StartMigratingRefreshSchedules property, run the following PowerShell script. The Script loops through all PowerPivot service application objects and display the name and property values:

   $apps = Get-PowerPivotServiceApplication
   foreach ($app in $apps){}
   Get-PowerPivotServiceApplication $appp | format-table -property displayname,id,StartMigratingRefreshSchedules
   

http://msdn.microsoft.com/en-us/library/ee210616.aspx

Thanks for the detail reply.

I still have below questions.

1- Is this not possible to take a backup of Power pivot service application using PowerShell ?

2- why this service application is not visible under CA >> Backup and restore >> Perform a Backup.

any outcome on this problem? i'm facing the same.