|
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.
| |||
|
feedback
|
|
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. | ||||
|
feedback
|
|
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 | |||
|
feedback
|
