Tuesday, November 6, 2012

Copying Content Databases to other SP 2007 Environments.... PART TWO MISNAMED DATABSE



So when I attached the new database back from TEST into DEV, I misnamed the new database (it had the name of an app within the database name that I found out later did not exist in the content database).  Now that I am on the straight and narrow path toward enlightenment, I needed to fix this to be concise.

Therefore...

1)  stsadm -o deletecontentdb -url (Site Collection URL) -databasename badDatabaseName

2)  SSMS - detach the badDatabaseName

3)  Restore from badDatabaseName backup into goodDatabaseName

3)  Rename the badDatabaseName to goodDatabaseName

4) stsadm -o addContentDb -url (Site Collection URL) -databasename goodDatabaseName

No comments:

Post a Comment