MOSS Forum

 
Home » Forum » MOSS       Ask a questionRSS Feeds

MOSS 2007 - Move Database Server

  Asked By: Lukas Nolan         Date: Mar 31, 2007      Category: MOSS      Views: 256
 

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.

Tagged:          

 

4 Answers Found

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

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, 2007       

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, 2007       

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.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].