Detach/attach SharePoint 2007 Configuration Database? RRS feed

  • Question

  • Hi, Due to some reason I have to move all the MOSS 2007 databases from one drive to another drive.

    Since I had already moved content databases and now want to move SharePoint config database , SharePoint Admin database, SSP and Search related database.

    And for movement using Detach/ Attach method.

    So please let me know while moving SharePoint config database , SharePoint Admin database, SSP and Search related database what precaution have to take?

    Thursday, September 19, 2013 10:39 AM


  • Here are the steps:

    Quiesce the Farm – This is especially important if you are working on a production system. Pretty much it takes the farm out of commission and doesn't allow any more sessions to be created.

    Backup all of the databases that you are looking to move.

    Be sure you have a current backup of any databases you will be fiddling with.

    Turn off SharePoint Services

    This will stop the connections to some of the databases. If you try to detach any of the databases you will find that some will have connections active. In case of the content databases you will probably find that the connections to the have already been taken care of. Either way you will need to stop some of the SharePoint services in order to get the search databases and config database totally disconnected.

    You can either stop the services through the Central Administration, or you can do it at the Services Console. I chose the services console since I didn't want to deal with typing in configuring the services again.

    To stop the connections to the existing databases stop the following services:
    Office SharePoint Search Service
    Windows SharePoint Services Administration
    Windows SharePoint Services Search
    Windows SharePoint Services Timer
    Windows SharePoint Services Tracing
    World Wide Web Publishing Service

    After the services are stopped, you should be able to detach the databases that you are looking to move.

    After detaching the databases navigate to where the data and log files are being stored and copy them to your destination.

    Reattach your databases.

    Restart your services.

    Un-quiesce the farm
    Thursday, September 19, 2013 10:48 AM