Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Trying to do a test with development virtuals and need to move the databases to a dedicated DB server (they are currently located on the development virtuals).

As part of the move I need to rename the databases.

Is there an easy way to rename the SharePoint databases.

share|improve this question
up vote 1 down vote accepted

That's not officially supported. There's a KB article about the supported database changes. You can use PSConfig to do it, but it's not what I would call easy.

share|improve this answer

Brent's right in that you don't want to go mucking about with the SharePoint databases, especially on a production system. If you do want to rename the databases on a non-production system (knowing that you may not be able to get support directly from Microsoft if you do so), I have put up a step-by-step here:

If your real question is how to move the databases to a separate SQL server, the steps are documented on TechNet here:

Move All Databases: Move Content Databases:


share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.