Reconnecting Content Databases in MOSS 2007

After the failover of a SharePoint Products and technologies database, it is required to reconnect the content databases. The following are the databases that are required to be reconnected,

• Content database
• Admin database
• Configuration Database
• Search Database
• Shared Services Provider

The following stsadm commands are used to reconnect to the content database after a failover, the deletecontentdb will remove the reference to the old database server and the addcontentdb will add the new database as the content database

stsadm –o deletecontentdb –url [Site] -databasename -databaseserver [Old Principal]

stsadm –o addcontentdb –url [Site] -databasename -databaseserver [Old Principal]

Reconnecting content databases can also be done using Central Administration,

1. Navigate to Central Administration.
2. Navigate to Application management page
3. Click on the Content Databases.
4. Select the content database that has failed-over.
5. In the Manage Content Databases page, choose the Remove content database option, and then click OK.
6. Select the Add a content database option, and enter the required details.
7. Replace the Database Server box with the new principal server, and then click OK.