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't 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.