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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tony303Commented:
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.
0
Justin SmithSr. 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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Tony303Commented:
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.
0
Minesh ShahSharePoint & all about itAuthor Commented:
tx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.