Move all databases to new SQL Server 2005

모든 응답

• 2009년 7월 4일 토요일 오후 12:57André Lage

   
  

  0

  로그인하여 투표
  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/
  • 응답
  • 인용

   
• 2009년 7월 5일 일요일 오후 12:09Hari2009

   
  

  0

  로그인하여 투표
  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
  

  • 편집됨Hari2009 2009년 7월 6일 월요일 오전 10:15
  •  
  • 응답
  • 인용

   
• 2009년 7월 6일 월요일 오전 2:27Xing-Bing Yu - MSFT

   
  

  0

  로그인하여 투표

  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
  • 응답
  • 인용

   
• 2009년 7월 6일 월요일 오전 6:12Hari2009

   
  

  0

  로그인하여 투표
  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

  • 편집됨Hari2009 2009년 7월 6일 월요일 오전 6:32
  • 편집됨Hari2009 2009년 7월 6일 월요일 오전 8:49
  •  
  • 응답
  • 인용

   
• 2009년 7월 7일 화요일 오전 3:06Xing-Bing Yu - MSFT

   
  

  0

  로그인하여 투표

  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

  • 답변으로 표시됨Xing-Bing Yu - MSFT 2009년 7월 13일 월요일 오전 1:09
  •  
  • 응답
  • 인용