Rename your SharePoint_AdminContent_guid database with stsadm mergecontentdbs operation

Hi,

 just a quick post to give you the commands to rename your Database on your SQL box of the Central Administration site. This is the only database that you cannot give a name yourself when setting up your MOSS environment.

Thanks to Service Pack 1 for WSS 3.0 you can now use the stsadm command mergecontentdbs instead of doing this operation on with a backup restore operation on the SQL box itself.

Here are the commands I used:

stsadm -o addcontentdb -url http://moss:1000 -databasename SharePoint_AdminContent_moss
stsadm -o enumsites -url http://moss:1000 > output.txt
stsadm -o mergecontentdbs -url http://moss:1000 -operation 3 -sourcedatabasename SharePoint_AdminContent_f58aa288-57e9-49ff-b953-9b4d53d50bfc -destinationdatabasename SharePoint_AdminContent_moss -filename output.txt
iisreset
stsadm -o deletecontentdb -url http://moss -databasename SharePoint_AdminContent_f58aa288-57e9-49ff-b953-9b4d53d50bfc

check with stsadm -o enumcontentdbs -url http://moss:1000

2 thoughts on “Rename your SharePoint_AdminContent_guid database with stsadm mergecontentdbs operation

Leave a Reply

Your email address will not be published. Required fields are marked *