1 Introduction
When installing SharePoint 2010 a lot of additional DB’s are created. This can be nasty from maintenance point of view, especially when a Central SQL server is used. Take a look at the next picture. This shows the worst case of DB naming. If these DB are stored on a central DB, you have known idea, if those DB are obsolete in one year, because you don’t know who used them.
We know how to change the DB name for:
- Microsoft Dynamics AX
- SharePoint_Config (define a correct name when installing SharePoint)
- WSS_Content (define a correct name when creating the Web Application)
Most of all other DB from SharePoint can be renamed with the SharePoint Administration tool or PowerShell. (Take a look at http://technet.microsoft.com/en-us/library/ff851878.aspx)
2 Change the names
2.1 SharePoint Admin
PowerShell
2.2 SharePoint Search
- Backup the Search_Service_Application_DB_GUID_ DB _ SQL
- Create new DB AxStart_ Search_Service_Application_DB
- Restore Search_Service_Application_DB_GUID_ DB _ SQL in the new created DB
- PowerShell
2.3 SharePoint State Service
PowerShell
2.4 Business Data Connectivity Service
In SharePoint Administrator Tool, Go to Manage Service applications. Select Business Data Connectivity Service and Properties, and change the DB Name
2.5 Search Service Application
In SharePoint Administrator Tool, Go to Manage Service applications. Select Search Service Application and Manage, on the next screen press modify button
2.6 Secure Store
In SharePoint Administrator Tool, Go to Manage Service applications. Select Secure Store and Properties, and change the DB Name
2.7 Select Web Analytics Server Application
In SharePoint Administrator Tool, Go to Manage Service applications. Select Web Analytics Server Application and Properties, on the pop screen select next button.
2.8 Web analytics and Health
In SharePoint Administrator Tool, Go to Manage Service applications. Select Web analytics and Health (WSS_Logging DB)
- Disable Enable Health Data Collection
- Disable Enable usage Data Collection
- Select OK
- Reopen the form and rename the DB
- Also enable the options again
- Delete the Old WSS_Longing DB manual in SQL
3 Mission accomplished
*This post is locked for comments