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.

Comments

# Windows 8 Not in 2012?; Windows Phone Marketplace Is Weak; Feds Want Cloud Email

Wednesday, October 27, 2010 7:59 AM by SharePoint Daily

Top News Stories Content Management Vendors Need to Work with SharePoint (The Frontline) Enterprise content

# Rename the SharePoint 2010 PerformancePoint database to remove the GUID

Thursday, November 04, 2010 12:47 PM by The SharePoint Farmer's Almanac

When I build a farm with the intention of not having any GUIDs I use the Central Administration page

# Rename the SharePoint 2010 PerformancePoint database to remove the GUID

Thursday, November 04, 2010 1:09 PM by Shane Young - The SharePoint Farmer's Almanac

When I build a farm with the intention of not having any GUIDs I use the Central Administration page

# SharePoint 2010 Database Naming Standards

Saturday, November 20, 2010 4:06 PM by John W Powell

In a previous post I made a case for following a database naming standard for SharePoint databases. 

# Tip: Take a moment to rename databases during a database attach upgrade

Tuesday, November 29, 2011 1:19 PM by To the SharePoint

SharePoint Products automatically generate GUID-based database names when databases are created, such

# Dica: reserve um tempo para renomear os bancos de dados durante uma atualização de anexação do banco de dados

Tuesday, February 07, 2012 2:47 AM by Blog da equipe do Microsoft SharePoint

Artigo original publicado na quarta-feira, 30 de novembro de 2011 Os Produtos SharePoint geram automaticamente

# Совет. Уделите время, чтобы переименовать базы данных во время обновления с присоединением

Tuesday, February 07, 2012 4:19 AM by Блог команды Microsoft SharePoint

Исходная статья опубликована в среду, 30 ноября 2011 г. При создании баз данных в продуктах SharePoint

# Suggerimento: ridenominare i database durante un aggiornamento del collegamento di database

Tuesday, February 07, 2012 6:58 AM by Microsoft SharePoint Team Blog

Articolo originale pubblicato mercoledì 30 novembre 2011 Quando si creano database, nei prodotti SharePoint

# 提示:在数据库附加升级期间花一些时间重命名数据库

Thursday, February 09, 2012 4:19 AM by Microsoft SharePoint 团队博客

原文发布于 2011 年 11 月 30 日(星期三) SharePoint 产品在数据库创建后自动生成基于 GUID 的数据库名称,如 WSS_Content_ 2a24a7ecde1744d4823e31d77b266653

# 팁: 데이터베이스 연결 업그레이드 중에 데이터베이스 이름 바꾸기

Friday, February 10, 2012 4:05 AM by Microsoft SharePoint 팀 블로그

최초 문서 게시일: 2011년 11월 30일 수요일 데이터베이스를 만들면 SharePoint 제품에서 WSS_Content_ 2a24a7ecde1744d4823e31d77b266653과

# 秘訣:在資料庫附加升級期間花一點時間重新命名資料庫

Monday, February 13, 2012 2:54 AM by Microsoft SharePoint 小組部落格

英文原文已於 2011 年 11 月 30 日星期三發佈 建立資料庫時,SharePoint 產品會自動產生 GUID 資料庫名稱,例如 WSS_Content_ 2a24a7ecde1744d4823e31d77b266653

# Tipp: Nehmen Sie sich beim Upgrade durch Datenbankanfügungen Zeit zum Umbenennen der Datenbanken

Monday, February 13, 2012 4:09 AM by Microsoft SharePoint-Teamblog

Veröffentlichung des Originalartikels: 30.11.2011 In den SharePoint-Produkten werden beim Erstellen

# 秘訣:在資料庫附加升級期間花一點時間重新命名資料庫

Wednesday, February 15, 2012 2:35 AM by Microsoft SharePoint 小組部落格

英文原文已於 2011 年 11 月 30 日星期三發佈 建立資料庫時,SharePoint 產品會自動產生 GUID 資料庫名稱,例如 WSS_Content_ 2a24a7ecde1744d4823e31d77b266653

# Tipp: Nehmen Sie sich beim Upgrade durch Datenbankanfügungen Zeit zum Umbenennen der Datenbanken

Wednesday, February 15, 2012 2:53 AM by Microsoft SharePoint-Teamblog

Veröffentlichung des Originalartikels: 30.11.2011 In den SharePoint-Produkten werden beim Erstellen

# Conseil : Prenez le temps de renommer les bases de données pendant une mise à niveau avec liaison des bases de données

Wednesday, February 15, 2012 3:05 AM by Blog de l’équipe Microsoft SharePoint

Article d’origine publié le mercredi 30 novembre 2011 Les produits SharePoint génèrent automatiquement

# Suggerimento: ridenominare i database durante un aggiornamento del collegamento di database

Wednesday, February 15, 2012 3:16 AM by Microsoft SharePoint Team Blog

Articolo originale pubblicato mercoledì 30 novembre 2011 Quando si creano database, nei prodotti SharePoint

# 팁: 데이터베이스 연결 업그레이드 중에 데이터베이스 이름 바꾸기

Wednesday, February 15, 2012 4:14 AM by Microsoft SharePoint 팀 블로그

최초 문서 게시일: 2011년 11월 30일 수요일 데이터베이스를 만들면 SharePoint 제품에서 WSS_Content_ 2a24a7ecde1744d4823e31d77b266653과

# Dica: reserve um tempo para renomear os bancos de dados durante uma atualização de anexação do banco de dados

Wednesday, February 15, 2012 4:33 AM by Blog da equipe do Microsoft SharePoint

Artigo original publicado na quarta-feira, 30 de novembro de 2011 Os Produtos SharePoint geram automaticamente

# Совет. Уделите время, чтобы переименовать базы данных во время обновления с присоединением

Wednesday, February 15, 2012 4:37 AM by Блог команды Microsoft SharePoint

Исходная статья опубликована в среду, 30 ноября 2011 г. При создании баз данных в продуктах SharePoint

# 提示:在数据库附加升级期间花一些时间重命名数据库

Wednesday, February 15, 2012 4:52 AM by Microsoft SharePoint 团队博客

原文发布于 2011 年 11 月 30 日(星期三) SharePoint 产品在数据库创建后自动生成基于 GUID 的数据库名称,如 WSS_Content_ 2a24a7ecde1744d4823e31d77b266653

Leave a Comment

(required) 
(required) 
(optional)
(required) 
If you can't read this number refresh your screen
Enter the numbers above: