Detach/attach SharePoint 2007 Configuration Database?

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?
LVL 10
Minesh ShahSharePoint & all about itAsked:
Who is Participating?
Justin SmithConnect With a Mentor Sr. System EngineerCommented:
The safest thing to do is to turn off all farm servers.  That way you know no interaction is happening with the databases.  Then do your normal detach and attach procedure.

If you cannot do this, make sure you stop all SharePoint services on your SP servers.  Also stop all IIS instances (iisreset /stop).  Then proceed with detach/attach.
Make full backups first after stopping any users from transacting in Sharepoint.
Verify the backups.

If all goes badly, you can restore these backups to your original system.

Then detach the databases, move them and attach on your new system.
I agree with Achilles, there are a lot of stored process that are in the Sharepoint config db that poll the other data bases constantly without any user input.

You will need to bring the sp servers up after your sqlserver in the new environment, I think if you start your sp server up first there will be connectivity issues.

Do the backups too, just in case.
Minesh ShahSharePoint & all about itAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.