Renaming service application databases

I have set up a SharePoint 2010 farm. Some databases have been configured by using PowerShell scripts. Therefore they have friendly names like SP2010_Config. I do not have made scripts for every configuration step yet so some database names are like this \WebAnalyticsServiceApplication_ReportingDB_2d5a77a9-8360-41cf-9294-14587f977d1d.

I would like to have nice looking names in my SQL server so I change the names of i.e. the WebAnalytics Service like this:

1. Go to Central Admin > Manage Service Applications
2. Select the Web Analytics Service Application:
   
3. Choose “Properties” in the ribbon:
4. Choose “Next” at the Edit Web Analytics Service Application screen
5. At the Edit Web Analytics Service Application Topology screen you can edit the database name:
   
6. Click on Reporting Database and choose “Edit Properties”:
   
7. In the next step you can change the database name:
8. When back in the Topology screen click “Next” and the changes are being processed:

   

Be aware: by doing this SharePoint will create new databases with the choosen name.

Tags: database, Howto, Service application, SP2010