How to move mysite webapplication database to another db server?

All replies

• 

  

  1

  Sign in to vote

  - Make mysite web application DB read only.

  - backup DB & restore to other server.

  - change content DB for web application from old DB to new DB server

  Let me know if this helps.

  • Proposed as answer by Sahni Sandeep Friday, November 1, 2013 7:34 PM
  • Marked as answer by Brooke Burke-Charvet Monday, November 4, 2013 2:45 PM

  Friday, November 1, 2013 7:33 PM
• 

  

  0

  Sign in to vote

  cool. How to you do the last part? "change content DB for web application from old DB to new DB server". I meant what is the powershell command. Is it the move-spsite powershell command?
  
  

  • Edited by Brooke Burke-Charvet Friday, November 1, 2013 8:06 PM

  Friday, November 1, 2013 8:04 PM
• 

  

  2

  Sign in to vote

  Manage content databases, select the mysite web app, click add content database, then specify the information for the new server is the gist of it.  See here for detailed directions:

  http://technet.microsoft.com/en-us/library/cc287899(v=office.14).aspx
  

  • Marked as answer by Brooke Burke-Charvet Monday, November 4, 2013 2:45 PM

  Friday, November 1, 2013 8:08 PM