Move SCOM DB Server

All replies

• 

  

  1

  Sign in to vote

  Hi

  There is official documentation for this:

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

  And there is real world info from the best source of SCOM information:

  http://blogs.technet.com/b/kevinholman/archive/2010/10/26/after-moving-your-operationsmanager-database-you-might-find-event-18054-errors-in-the-sql-server-application-log.aspx

  http://blogs.technet.com/b/kevinholman/archive/2010/08/25/moving-the-data-warehouse-database-and-reporting-server-to-new-hardware-my-experience.aspx

  Cheers

  Graham

  ---

  New SCOM 2012 Blog! - http://www.systemcentersolutions.com/blog/
  View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

  • Proposed as answer by Samuel Tegenfeldt Friday, January 27, 2012 7:55 AM
  • Marked as answer by Nicholas Li Tuesday, January 31, 2012 10:51 AM

  Friday, January 27, 2012 6:26 AM
• 

  

  0

  Sign in to vote

  Before you move, please pay attention on new DB server - SQL collation (it's recommended to be SQL_Latin1_General_CP1_CI_AS). That will help you to avoid a lots of problems.

  http://www.systemcentercentral.com/BlogDetails/tabid/143/IndexID/90671/Default.aspx

  Saturday, January 28, 2012 9:13 AM
• 

  

  0

  Sign in to vote

  Hi

  Just to clarify - the collation is required to be SQL_Latin1_General_CP1_CI_AS for a supported configuration:

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

  Cheers

  Graham

  ---

  New SCOM 2012 Blog! - http://www.systemcentersolutions.com/blog/
  View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

  • Proposed as answer by Nicholas Li Tuesday, January 31, 2012 10:51 AM
  • Marked as answer by Nicholas Li Tuesday, January 31, 2012 10:51 AM

  Saturday, January 28, 2012 9:45 AM