moving all sharepoint database from 1 instance to another?

Hi,

I have installed a second instance of SQL Server on my server.
this new installation is SQL2005 while the old one is SQL2000.
its a side by side installation, not an upgrade.

But now, I want to move all the sharpeoint databases from the SQL2000
instance to the SQL2005 one.

I'll stop my services and detach from SQL2000, reattach to SQL2005 the
databases.
but after, what I have to do?
and in which order?

thanks.

Jerome.

Russ
Fri Jan 06 07:01:01 CST 2006

For startes you'll need to make sure that SP2 for WSS is installed.
Then you'll need to reconfigure the content and configuration databases
using the WSS Central Administration. Look for Set content database
and set configuration database. There may be other steps required but
this should get you moving in the right direction.

Russ

J=E9j=E9 wrote:
> Hi,
>
> I have installed a second instance of SQL Server on my server.
> this new installation is SQL2005 while the old one is SQL2000.
> its a side by side installation, not an upgrade.
>
> But now, I want to move all the sharpeoint databases from the SQL2000
> instance to the SQL2005 one.
>
> I'll stop my services and detach from SQL2000, reattach to SQL2005 the
> databases.
> but after, what I have to do?
> and in which order?
>=20
> thanks.
>=20
> Jerome.