Export (0) Print
Expand All

Rename the App Management Service service application databases in SharePoint 2013

SharePoint 2013
 

Applies to: SharePoint Server 2013, SharePoint Foundation 2013

Topic Last Modified: 2014-06-23

Summary: Learn how to rename the App Management Service service application databases in SharePoint 2013.

You can rename the App Management Service application databases by using the SharePoint Central Administration website, Windows PowerShell, or SQL Server tools. Which backup tool you use depends on what kind of environment you have deployed, what your backup schedule requires, and what service level agreements you have made with your organization.

In this article:

Renaming service application databases is typically done to remove the GUID from the database name after the databases were created by the SharePoint Products Configuration Wizard, or to bring the databases into alignment with your organization's naming standards.

The general process for renaming or moving service application databases is as follows:

  1. Rename the database by using SQL Server tools.

  2. Point the service application to the renamed database.

NoteNote:
Because SharePoint 2013 runs as websites in Internet Information Services (IIS), administrators and users depend on the accessibility features that browsers provide. SharePoint 2013 supports the accessibility features of supported browsers. For more information, see the following resources:
ImportantImportant:
The account, or accounts, performing the operations, you must have the following rights and permissions:
  • A member of the Farm Administrators SharePoint group.

  • A member of the Administrators group on the local server

  • Have read permission on the source location and write permission on the target location.

  • Have the db_owner fixed database role for all of the databases that you are moving.

In some environments, you must coordinate the rename and move procedures with the database administrator. Be sure to follow any applicable policies and guidelines for managing databases.

To rename a service application database, you must use SQL Server. To move a service application database, you must use SQL Server and Windows Explorer. We recommend that you stop the services related to the service application before you rename or move the related database. In general, we expect that you will either rename or move a database. That is, you will typically not perform both actions.

The instructions in this article assume that you have installed SQL Server Management Studio on the database server. If this is not the case, you can download and install Management Studio at Microsoft SQL Server 2008 R2 RTM - Management Studio Express (http://go.microsoft.com/fwlink/p/?LinkID=186132&clcid=0x409).

To stop the service application
  1. Verify that the user account that is performing this procedure is a member of the Farm Administrators SharePoint group.

  2. For each service application that you plan to change the database for, you must stop the service or disable the service application by following the appropriate procedure for the service application that you are working with. For more information, see Start or stop a service (SharePoint 2013).

To rename the App Management Service application database by using SQL Server Management Studio
  1. In SQL Server Management Studio, connect to the source SQL Server instance, and then expand the Databases node.

  2. Right-click the database that you want to rename, click Rename, and then type the new name. Repeat this step for each database that you want to rename.

You can point the App Management service application to a renamed or moved database by using Central Administration or Windows PowerShell.

NoteNote:
You do not have to stop the App Management service before pointing to a renamed or moved database. However, stopping the App Management service will not cause a problem if you choose to do this.
To point the App Management Service application to a renamed database by using Central Administration
  1. Verify that the user account that is performing this procedure is a member of the Farm Administrators SharePoint group.

  2. In Central Administration, under System Settings, click Manage services on server.

  3. In the Service list, next to the App Management service, click Stop.

  4. In the Quick Launch, click Application Management.

  5. On the Application Management page, click Manage service applications.

  6. On the Manage Service applications page, click the empty area in the row next to the App Management Service name. The ribbon becomes active.

    NoteNote:
    You must click the empty area to activate the ribbon on the Manage Service applications page. If you click App Management Service, the settings page opens for this service application.
  7. Click Properties on the ribbon.

    The Edit App Management Service Application dialog box appears.

  8. Change the database server or database name, and then click OK.

  9. In the Quick Launch, click System Settings.

  10. On the System Settings page, under Servers, click Manage services on server.

  11. In the Service list, next to the App Management Service, click Start.

To point the App Management Service application to a renamed database by using Windows PowerShell
  1. Verify that you have the following memberships:

    • securityadmin fixed server role on the SQL Server instance.

    • db_owner fixed database role on all databases that are to be updated.

    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.

    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.

    NoteNote:
    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, see Add-SPShellAdmin.
  2. Start the SharePoint 2013 Management Shell.

    • For Windows Server 2008 R2:

      • On the Start menu, click All Programs, click Microsoft SharePoint 2013 Products, and then click SharePoint 2013 Management Shell.

    • For Windows Server 2012:

      1. On the Start screen, click SharePoint 2013 Management Shell.

        If SharePoint 2013 Management Shell is not on the Start screen:

      2. Right-click Computer, click All apps, and then click SharePoint 2013 Management Shell.

    For more information about how to interact with Windows Server 2012, see Common Management Tasks and Navigation in Windows Server 2012.

  3. At the Windows PowerShell command prompt, type the following command:

    $app = Get-SPServiceApplication | where {$_.displayname -match "<AppManagementServiceName>"
    

    $db = Get-SPScaleOutDatabase -ServiceApplication $app |where {$_.Name -match "<OriginalDatabaseName>"
    

    Where:

    • <AppManagementServiceName> is the name of the App Management Service application that you want to rename.

    • <OriginalDatabaseName is the original name of the App Management Service application database that you want to rename.

  4. At the Windows PowerShell command prompt, type the following command:

    Remove-SPScaleOutDatabase -ServiceApplication $app -Database $db
    Add-SPScaleOutDatabase -ServiceApplication $app -Database <NewDatabaseName>
    

    Where:

    • <NewDatabaseName> is the new name of the App Management Service application database.

For more information, see Get-SPServiceApplication.

NoteNote:
We recommend that you use Windows PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product versions.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft