Hi, we plan to move our SQL databases to new SQL instance.

For this migration effort, before we disconnect each of our medium server
farm servers from configuration database, do we have to remove that server
from component roles (change component settings page).
Or, Just disconnect each server in farm from configuration database and
reconnect to existing database (i.e., same database moved to new SQL Server)
would work without any issues???

Or Am I completely wrong on moving databases.

Re: disconnecting from configuration database by Bill

Bill
Sat Jan 29 07:17:18 CST 2005

Yes, before you disconnect a server from a configuration database, the
server has to be removed from all its farm roles.

--

Bill English
www.mindsharp.com
www.mindsharpblogs.com
sharepointdiscussions@yahoogroups.com


"vamsi" <vamsi@discussions.microsoft.com> wrote in message
news:12C02E21-48E9-4AF0-AB97-1A5D4AB77B82@microsoft.com...
> Hi, we plan to move our SQL databases to new SQL instance.
>
> For this migration effort, before we disconnect each of our medium server
> farm servers from configuration database, do we have to remove that server
> from component roles (change component settings page).
> Or, Just disconnect each server in farm from configuration database and
> reconnect to existing database (i.e., same database moved to new SQL
> Server)
> would work without any issues???
>
> Or Am I completely wrong on moving databases.