Moving SPS/WSS Databases

Moving SPS/WSS Databases

Post by T3dlbnNaaW » Fri, 22 Apr 2005 04:06:02

I am trying to move a SPS database from one SQL server to another. The other
roles will remain on the servers they originally started from. I can seem
to find anything on how this is done. Backing up the database is no problem,
but pointing the portal to the new server seems to be an issue.

I also have several WSS sites under the portal that have their own databases
and can see no way to redirect these as well.

Any suggestion would be greatly appreciated.

Moving SPS/WSS Databases

Post by QHJyb2J » Fri, 22 Apr 2005 12:18:02

You could probably tryed to disconnect the databases first from the
sharepoint central administration, and then in the components settings also
the server, then you can specify another SQl instance and so on, the
configuration of your database.. I dont know if you allready tryed this....