SharePoint DB Names

• sindhigrl

  Default port

  Points: 1448

  More actions

  November 16, 2011 at 5:48 pm

  #251920

  We installed SharePoint 2010 on SQL 2008 and with it we had about 18 databases installed with names like 'Managed Metadata Service_fd8c8bac416349a1af8463947b9c771c' and 'PerformancePoint Service Application_c1de80ec859e49deab165e637d85bc74'. Really nasty names...I knew from working with Sharepoint in a previous life that the names were bad and I asked our vendor to change them during installation, but he didn't or couldn't- not sure which.

  Anyone have experience with changing the names to something much shorter and sweeter? I'm planning on making the changes in our sandbox environment first, but was wondering if there was anything I should be aware of.

  Thanks!

  Anita

  Thanks!

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  November 17, 2011 at 12:07 am

  #1408983

  Useful links:

  http://blogs.technet.com/b/seanearp/archive/2009/03/14/renaming-crazy-sharepoint-database-names.aspx

  http://www.raregrooverider.com/post/2008/02/04/Renaming-a-SharePoint-Central-Administration-Database-with-a-GUID-Appended-to-the-Database-Name.aspx

  http://msmvps.com/blogs/shane/archive/2010/11/04/rename-the-sharepoint-2010-performancepoint-database-to-remove-the-guid.aspx

  Some article said you could change the names of most of the databases during installation. This was 2007, so I don't know if it is still possible for SharePoint 2010.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP