Move all databases to new SQL Server 2005

All Replies

• Saturday, July 04, 2009 12:57 PMAndré Lage

   
  

  0

  Sign In to Vote
  You could need some stsadm commands in the middle step to detache ssp databases and other issues and security issues, 

  Follow the manual step by step, will help you prepare everything.

  
  

  "Moving all databases to a different database server or a server with the same name"

  http://www.microsoft.com/downloads/details.aspx?FamilyID=65686896-C171-46A8-A95F-54F43AD79952&displaylang=en

  
  

  Move all databases (Office SharePoint Server 2007)

  http://technet.microsoft.com/en-us/library/cc512725.aspx

  
  

  Hope this help.

  ---

  André Lage Microsoft SharePoint and CRM Consultant
  Blog:http://aaclage.blogspot.com
  Codeplex:http://spupload.codeplex.com/http://simplecamlsearch.codeplex.com/
  • Reply
  • Quote

   
• Sunday, July 05, 2009 12:09 PMHari2009

   
  

  0

  Sign In to Vote
  Hi Andre,
  
  Thanks for your post.
  Downloaded & read the document shared in first article.
  
  I have below doubt.
  
  Why we need to backup & restore SSP ? given from Step 3 -5 in the document?
  I am just going for new database server so backup & restore only the database will not work?
  
  Regards,
  Hari
  

  • Edited byHari2009 Monday, July 06, 2009 10:15 AM
  •  
  • Reply
  • Quote

   
• Monday, July 06, 2009 2:27 AMXing-Bing Yu - MSFT

   
  

  0

  Sign In to Vote

  Hello,

   

  The document that Lage provided are good guidance just meet your need.

   

  For your questions about backup & restore SSP databases:

   

  In fact, SSP (shared services provider) will only appear at MOSS 2007, it has a particular database which is different from other content databases. So, if you have WSS 3.0, you can ignore this step and only perform backup & restore on content database as you’ve already known.

   

  If you are under MOSS 2007 environment, then to backup & restore SSP database is useful. It can recover your settings and configuration about SSP so that no modification will lost. But, if saving the past configuration of SSP is not necessary or you just want to create new SSP, then this step is optional. You can migrate only content databases then create new SSP database in the new server as you like.

   

  Regards,

  Jerry

  ---

  Xing-Bing Yu
  • Reply
  • Quote

   
• Monday, July 06, 2009 6:12 AMHari2009

   
  

  0

  Sign In to Vote
  Hi Jerry,
  
  Thanks for your reply.
  Pls guide me for below clarification.
  I have 2 server , one for application(WindowsServer2003 with MOSS2007) & another for database(WindowsServer2003 with SQL Server 2005) .
  
  Below are list of my databases from my server.
  
  System Databases
  DatabaseSnapshots
  BOD_Content
  Intranet_serarch_sharepointapp
  IntranetSPP_content
  Mysite_content
  sharepoint_AdminContent
  sharepoint_config
  IntranetDb_content
  IntranetMysite_content
  IntraneSSP_DB
  IntranetSSP_Serach_DB
  
  
  Now i need to go for new database server bcoz of no free disk space issue, so i need to take backup of all database from my old DB Server & deploy in new server.
  And i need to associate the new DB Server in my Applciation server.
  
  Is this enough? do i need to take any special care for SPP?
  
  Regards,
  Hari

  • Edited byHari2009 Monday, July 06, 2009 6:32 AM
  • Edited byHari2009 Monday, July 06, 2009 8:49 AM
  •  
  • Reply
  • Quote

   
• Tuesday, July 07, 2009 3:06 AMXing-Bing Yu - MSFT

   
  

  0

  Sign In to Vote

  Hello,

   

  According to your condition, the following two links are exactly what you need to check:

   

  Moving the SharePoint Databases to a new SQL server instance:

  http://blogs.msdn.com/shaden/archive/2007/07/05/moving-the-sharepoint-databases-to-a-new-sql-server-instance.aspx

   

  SharePoint 2007 - Move Content and Configuration Databases

  http://sharepointsherpa.com/2008/04/18/sharepoint-2007-move-content-and-configuration-databases/

   

  Regards,

  Jerry

  ---

  Xing-Bing Yu

  • Marked As Answer byXing-Bing Yu - MSFT Monday, July 13, 2009 1:09 AM
  •  
  • Reply
  • Quote