Moving Sharepoint Configuration Database
Found this great article on how to move sharepoint configuration databases across servers:
http://sharepointsherpa.com/2008/04/18/sharepoint-2007-move-content-and-configuration-databases/
Instructions for moving a configuration database from one SQL server to another
1.Backup configuration database from the source SQL server
2.Restore the backup onto the target SQL server (Note: this is your opportunity to rename the config database if desired)
3.Run the following stsadm commands from the command line on your SharePoint server to complete the move: (Note: the deleteconfigdb does not actually delete the database from SQL server, it simply disconnects the database from SharePoint)
stsadm -o deleteconfigdb
stsadm –o setconfigdb -connect –databaseserver target_SQL_server -databasename databasename -farmuser your_farm_sql_account -farmpassword your_farm_sql_password
But psconfig is the new command to use. Check out: http://technet.microsoft.com/en-us/library/cc263093.aspx
Creates, connects, or disconnects this server from the server farm. Takes the following optional parameters:
[-create]
Creates a new configuration database and thus establishes a new server farm. If this server is already connected to a configuration database, the server will be disconnected first, and then the new configuration database will be created.
[-disconnect]
Disconnects this server from the configuration database and thus disconnects this server from the server farm.
[-connect]
Connects to an existing configuration database and thus joins this server to an existing server farm. If this server is already connected to a configuration database, the server will be disconnected first, and then connected to the existing configuration database.
[-server
] The computer running SQL Server where the configuration database is located.
[-database
] The configuration database name.
[-dbuser
] The user name used for SQL authentication.
[-dbpassword
] The password used for SQL authentication.
[-user
] The server farm administrator user account.
[-password
] The server farm administrator user account password.
[-addomain
] The Active Directory domain name used for the server farm.
[-adorgunit
] The Active Directory organization unit name used for the server farm.
[-admincontentdatabase
] The Central Administration Web application content database name.
Examples
psconfig.exe -cmd configdb -create -server
-database -dbuser
-dbpassword -user
-password -addomain
-adorgunit -admincontentdatabase
psconfig.exe -cmd configdb -disconnect
psconfig.exe -cmd configdb -connect -server
-database -dbuser
-dbpassword
Filed under: Computing, Sharepoint
