Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Move Databases to another server

  Asked By: Ryan    Date: Nov 21    Category: Sharepoint    Views: 12650

I have the need to move all the Sharepoint Portal and WSS databases from 1 database server to another. Is this as straight forward as one would think? Can I just backup and restore the databases from 1 server to the other, maintaining the permissions for each and repoint Portal to the new server?



3 Answers Found

Answer #1    Answered By: Randall Hunt     Answered On: Nov 21

I am in a similar situation... here is where I am at and what I need
to do.

We set up a WSS server  and ran it on MSDE for a few months... now
that we are out of the pilot phase we want to "simply" migrate the
MSDE databases  (content & config??) to a SQL server. This sounds
like a pretty simple task but I am not sure where to start... seems
like there has to be some instructions out there somewhere for this
as I would guess this is a fairly routine occurance.

Answer #2    Answered By: Joe Hart     Answered On: Nov 21

Actually this looks like the document that I am looking for .. what
I am unsure about is that it is referencing STS not WSS all over and
after the first three sections of the doc it starts in with Office
XP and on from there I guess I don't know if that is something that
is listed as an alternate method or what...


Answer #3    Answered By: Jorge Cole     Answered On: Nov 21

I'm not too sure what you'll need to do if only using WSS without Portal, but with Portal, I've found that I had to use the SharePoint Portal Backup / Restore to perform this move.

Steps that worked for me:
1. From SPSBackup - Backup Everything (You can even include other WSS sites you have on that server).
2. From SQL Enterprise Manager - Add Application Pool User to database  server.
3. From Central Administration - Remove server  Roles from all Servers.
4. From Central Administration - Remove extensions from each virtual server used.
5. From Central Administration - Disconnect from Configuration Database.
6. From Central Administration - Create new Configuration Database on new Database server.
7. From SPSBackup - Restore Complete Backup selecting the new Database server and/or Portal URL (if changing Portal URL).
8. Delete all original Databases.

I have since found the following article which gives a bit more detail to the above steps:

Here is another article that may help those with just WSS and are moving the Database to a different server:
*note: if you are not changing servers, you can simply upgrade the WMSDE database to SQL server in place.

Didn't find what you were looking for? Find more on Move Databases to another server Or get search suggestion and latest updates.