SharePoint 2013 Tutorial - Rename SharePoint_AdminContent Database

Visit SharePoint Training Online at http://www.sharepointtrainingonline.com

View this videos webpage for more information at http://www.sharepointtrainingonline.com/rename-sharepoint_admincontent-database/

Series of Renaming SharePoint 2013 Databases

This is the first of a series where we are renaming the SharePoint 2013 Databases. Here, we start with renaming SharePoint_AdminContent_[GUID] database. These steps can be used with SharePoint 2010 as well.

Create a new Central Administration Content Database:
New-SPContentDatabase -Name SharePoint_AdminContent -WebApplication http://[central admin url:port]

Get a list of Central Administration Content Databases:
Get-SPWebApplication -Identity http://[central admin url:port] | Get-SPContentDatabase | Select Id, Name, WebApplication | Format-List

Copy database content:
Get-SPSite -ContentDatabase [old database Id GUID] | Move-SPSite -DestinationDatabase [new database Id GUID]

Execute command IISRESET.

Delete the old database:
Remove-SPContentDatabase [old database Id GUID]

Confirm the old database has been removed from SharePoint:
Get-SPWebApplication -Identity http://[central admin url:port] | Get-SPContentDatabase | Select Id, Name, WebApplication | Format-List

References:
Good blog walk-through:
http://www.mssqltips.com/sqlservertip/2706/renaming-the-sharepoint-admin-content-database-to-follow-sql-server-naming-conventions/

New-SPContentDatabase: http://technet.microsoft.com/en-us/library/ff607572.aspx
Get-SPWebApplication: http://technet.microsoft.com/en-us/library/ff607562.aspx
Get-SPContentDatabase: http://technet.microsoft.com/en-us/library/ff607828.aspx
Get-SPSite: http://technet.microsoft.com/en-us/library/ff607950.aspx
Move-SPSite: http://technet.microsoft.com/en-us/library/ff607915.aspx
Remove-SPContentDatabase: http://technet.microsoft.com/en-us/library/ff607920.aspx