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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment