Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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: http://blogs.technet.com/seanearp/archive/2009/03/14/renaming-crazy-sharepoint-database-names.aspx

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: http://technet.microsoft.com/en-us/library/cc512725.aspx Move Content Databases: http://technet.microsoft.com/en-us/library/cc263037.aspx

-Sean

share|improve this answer

Your Answer

 
discard

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.