Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Blogs / AXStart / Get in control with Sharepo...

Get in control with Sharepoint DB names

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

  • Remove the old Bdc_Service_DB manually on SQL!

 

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

  • You can change Crawl & Property DB Name
  • Don’t forget to press the apply topology button

 

2.6      Secure Store

In SharePoint Administrator Tool, Go to Manage Service applications. Select Secure Store and Properties, and change the DB Name

  • Remove the old Secure_Store_DB manually on SQL!

 

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.

  • Change the names and select next
  • Delete the OLD DB manually on SQL!

 

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

 

Comments

*This post is locked for comments