Getting rid of GUIDs in SharePoint 2010 database names

It is like your typical battle of good vs. evil. SharePoint 2010 has a secret plot to run the world out of GUIDs and between you and me I think it has a good shot of accomplishing its goal. Well, me and boy wonder (aka Todd) have seen the pain and suffering they are trying to evoke and we have plan to stop it. Creating blog posts to remove as many of the GUIDs as possible.


“But dynamic duo who cares if the world runs out of GUIDs?” Well, to be honest the people it scares the most are the poor developers. And while we generally consider developers second class citizens that doesn’t mean we wish them harm. And let’s face it, if they didn’t have GUIDs they would have nothing to do. And we all know bored developers will wander the halls of your office building aimlessly. Or worse they will congregate in places like the break room and will want to make small talk with you when you go to get an afternoon Mt. Dew. I don’t know about you, but nothing ruins my day worse than idle chit-chat with a developer. Yucky.


So this post is your one stop shopping for everything about getting rid of the GUIDs: As Todd or I post new items for removing GUIDs we will update this post.


How to get rid of the Central Admin database GUID by Todd


How to get rid of the SharePoint 2010 Search service application database GUIDs by Shane


How to clear timer job error after renaming the Search Admin database by Shane 


Microsoft article on renaming databases (Be careful, it isn’t perfect yet)


How to rename the PerformancePoint Database by Shane 


Build your farm without getting GUIDs in the first place by Todd


As always remember to test any of these steps on a nonproduction server before attempting on your real servers.


Save the GUID!


Shane


SharePoint Consulting


PS – I don’t hate developers. Really, it just seems that way.

5 thoughts on “Getting rid of GUIDs in SharePoint 2010 database names”

  1. This is a great blog document and much needed in ensuring that projects lead to value. It would be of great help to have some generic examples of benefit maps etc included in the guideline. I have just started out in the benefits management areana, find it very useful, but am still finding my feet on the practical application.

  2. Hi Todd,

    Thanks for the links in your blog. I really need the link for ‘Build your farm without getting GUIDs in the first place’ but one link is broken can you please fix it. It would save be loads of time as I’m doing a fresh install of Sharepoint 2010.

    Thanks again.
    LK

  3. Shane,

    I just wonder have you ever notice on crawl log history using Western Timestamp even though region setting and clock on server set to Eastern Time. Can we change crawl log using eastern timestamp?

Leave a Reply

Your email address will not be published. Required fields are marked *


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>