Thursday, 5 October 2017

Backup and Restore Service Applications in SharePoint 2013

Finding the path of a service application in SharePoint 2013

Open the SharePoint Administration Shell and enter: Backup-SPFarm -ShowTree
Backup-SPFarm -Directory "C:\Backup" -BackupMethod Full -Item "Farm\Shared Services\Shared Services Applications\User Profile Service" –Force

(OR)

SQL Backups for Service Applications with Database Content

There are five service applications that hold content in databases that you can backup directly from SQL. You can’t get both the service application settings and the content this way, but you can usually recreate the service applications without much trouble and then just leverage the content from the backed up service applications by performing a database restore from your SQL backup and set the destination to be the new service application database.
The service applications components that you can backup directly from SQL are:
–        Search Administration (but not the index)
–        Business Data Connectivity
–        Secure Store
–        User Profile Service social database
–        User Profile Service profile database
–        Managed Metadata
Those databases can be backed up and restored through the SQL Server Management Studio. Using this approach, you can easily create a service application on a new farm, and then use SQL Server Management Studio to restore the backed up copy of the service application database over the newly created one.

No comments:

Post a Comment