MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

MOSS 2007 - Move Database Server

  Asked By: Lukas    Date: Mar 31    Category: MOSS    Views: 898

Does anybody know the steps required to move all MOSS2007 databases
from one SQL2005 server to another SQL2005 server? Any help would
really be appreciated.



4 Answers Found

Answer #1    Answered By: Marty Mcdowell     Answered On: Mar 31
Answer #2    Answered By: Dakota Shaffer     Answered On: Mar 31

This looks like it is more to move  content DBs from 1 web app to
another. I am looking to take all databases (config, content,
mysites, admin, shared svcs, etc) from one SQL server  to another but
otherwise keep my farm the same.

I would think this should be relatively common but have been unable
to find any information on the steps to perform it properly.

Answer #3    Answered By: Ted Gilmore     Answered On: Mar 31

The process is essentially the same. After you run preparetomove on the
content database, simply back it up, move  it to the other SQL server  and
then re-attach the copy the way the article says.

Answer #4    Answered By: Monte Cooley     Answered On: Mar 31

We are working on a white paper that will describe this process in
depth. I believe that is it slated for one of the next two newsletters.

Didn't find what you were looking for? Find more on MOSS 2007 - Move Database Server Or get search suggestion and latest updates.