Guidance on renaming the multitude of databases generated by SharePoint 2010

Jeroen Ritmeijer - Muhimbi
  • Guidance on renaming the multitude of databases generated by SharePoint 2010 Jeroen Ritmeijer - Muhimbi

    SharePoint 2010 appears to continue SharePoint 2007's tradition of automatically creating horribly named SQL Databases. Like many companies we have multiple farms and developer workstations connecting to a central database server.

    To make sure things don't become messy and difficult to manage, we prefer to use database names such as:

    • DEV_WS004_SharePoint_AdminContent
    • DEV_WS004_User Profile Service Application_ProfileDB

    rather than:

    • SharePoint_AdminContent_9fc4ac7c-6895-4a74-bf10-df6ac4c2c1d6
    • User Profile Service Application_ProfileDB_a17efbf6942341f785c69829ce7f2d97

    I am creating this question so we can create a central repository for renaming the various databases. I will try to find as many answers as possible myself, but would appreciate answers from the community as well.

    At the moment the following databases have priority, but as we only have a limited set of services enabled I know there are many more.

    • SharePoint_AdminContent_[some guid]
    • Managed Metadata Service_[some guid]
    • Search_Service_Application_CrawlStoreDB_[some guid]
    • Search_Service_Application_DB_[some guid]
    • Search_Service_Application_PropertyStoreDB_[some guid]
    • User Profile Service Application_ProfileDB_[some guid]
    • User Profile Service Application_SocialDB_[some guid]
    • User Profile Service Application_SyncDB_[some guid]
    • WordAutomationServices_[some guid]
    • WSS_UsageApplication

    Update: If you have multiple SharePoint 2010 farms connected to a single database server then you can see which databases belong to a farm on the following Central Administration screen: http://[Your CA Server]/_admin/DatabaseStatus.aspx. (CA / Upgrade and Migration / Review database status)

    Update2: See this blog post on SharePoint 2010 Databases.

  • To rename the SharePoint_AdminContent_[some guid] database the process is the same as under SharePoint 2007.

    1. Run as a user with the appropriate privileges to make these changes.

    2. stsadm.exe -o deletecontentdb -url http://[ca server]:[ca port] -databasename SharePoint_AdminContent_[some guid] -databaseserver [Your DB Server]

    3. Rename the database using a tool / script of your choice. We used SQL Management Studio. You may need to restart the SharePoint 2010 Timer service to make sure all connections to the DB are released or you will not be able to rename it.

    4. stsadm.exe -o addcontentdb -url http://[ca server]:[ca port] -databasename [Your new Database Name] -databaseserver [Your DB Server]

Tags
database guidance best-practices
Related questions and answers
  • I have created a "Hello World" web part. When I pressed F5 in Visual Studio 2010, I got the following error. I have already got Microsoft SharePoint Foundation User Code Service started. Can anyone... Application Registry Service 46e7ddc8-49af-4a7e-9eee-155f526ed509 Microsoft SharePoint Foundation User Code Service... 9bc7d7a7-37c2-43e2-a764-9d8a0d2d4e4c SharePoint Server Search 10243b97-ace5-41bb-a4da-0bd3ad65ca73 Document Conversions Launcher Service

  • added another server to the farm, moved the central admin with the stsadm tool, and removed the old server from the farm. Here is what I have tried: Deployed to two other farms: successfully deployed... with no errors Checked the databases (namely config) to see if there are quota/growth/space issues. There were no errors. What else can I check? Typically, we can use the errors in the logs as a basis..., we were lucky enough to still have the soon to be decommisioned server that previously ran Central Admin (Server1). So, I added the server to the farm. Removed the Central Admin from the new Server

  • When I go to manage service applications in Central Administration and try to create a new service application like: New > Create a new service application, the link isn't active. My issue is I would like to create a Search Service Application after installing Search Server Express 2010. Do I need to run the Farm Configuration Wizard and install the below if I can create a Search Service... the possibility to create a new search service apps? The only new link i can see on the service application page menu is to create BDC service. alt text http://www.freeimagehosting.net

  • We recently migrated some applications from SharePoint 2007 to SharePoint 2010. The application uses the SiteData.asmx web service. After the migration there are Access Denied errors, withtout any... with claims based authentication? Update The real issue is Multiple Membership Providers not really working in a lot of situations. We have to following issues: legacy web services do not fully work. odata... be opened. For applications using SharePoint web services we will extend the web application and have an internal url with only Windows authentication enabled.

  • Scenario: We have an internal application that ties Excel spreadsheets stored in a SharePoint doc lib with specific Opportunities in CRM. The user clicks on a button in the Opportunity and a Web... user can open it for editing? Is there any way through the SharePoint UI or APIs to tell who SharePoint thinks has the document open for editing (although in some cases that seems like it is going.... Note that this is just opening the Excel file without checking it out. Problem: Once in a while, and for no reason I can figure out, a user will click the button and the spreadsheet will be returned

  • servers and tried creating the Central Admin website on WSS3, where SharePoint already thinks it is. But for some reason SharePoint is creating the alternate access mappings using SSL, and we don't have a certificate for the server. Why is SharePoint creating alternate access mappings routing an https internal URL by default? How can we move central administration to a new server? We are using...We have several WSS Servers: WSS1 WSS2 WSS3 WSS4 SharePoint thinks that Central Administration is on WSS3 and that it can be access via SSL on port 22641. The problem is that central

  • I have created a simple survey with SharePoint Server 2010 with the intent of allowing all our domain users to access and complete it. I added some basic branching logic to this survey as well... and clicking the "Next" button, they receive an Access Denied error. Thinking that the branching may have been causing an issue, I removed it. The users can now see the whole survey at one time, but when they try to submit their answers they still received the Access Denied error. I have tried sending an access request from a test user (as prompted by the error page), but I still received the same error

  • in the index under the contentclass:STS_Site and the sites (SPWeb's) are contentclass:STS_Web. The following people seem to have come across this issue and assumed it was just a limitation. I think... have observed to exhibit this 'bug' is: a site collection or site is based on a publishing template (can be built-in e.g. collaboration portal or custom site template) SharePoint 2007 with updates... only site collections/sites using non-publishing templates. All other content is availble e.g. documents, lists Has anyone else come across this? UPDATE 08/05/10: I have been doing some further

  • I want to import user profiles in MOSS 2007 server into my SharePoint 2010 server. Can anyone please suggest how can i go about achieving the same. Can we import user profiles using Business Data Connection in Configure Synchronization Connection in User Profile Service Application in SharePoint 2010. Why i am doing this: I want to crawl MOSS 2007 User Profile Database in SharePoint 2010.

Data information