As per SCOM 2007 R2 Design guide Disaster Recovery Functionality "In SCOM 2007 R2, all interactions with the OperationsManager database are recorded in transaction logs prior to being committed to the database. Those transaction logs can be sent to another Microsoft SQL Server 2005 SP1 or higher or Microsoft SQL Server 2008 SP1 server and committed to a copy of the OperationsManager database there. This technique is called log shipping. The destination, or failover, management group does not need to be a fully populated and active management group. It can consist of only a root management server (RMS) and a SQL Server 2005 SP1 or higher or SQL Server 2008 SP1 server. If it is necessary to execute a failover, the remaining management servers in the source management group require a registry change and a restart to start acting as members of the failover management group." The supported SQL vesions given above are Microsoft SQL Server 2005 SP1 or higher or Microsoft SQL Server 2008 SP1 server. Is SQL Server 2008 R2 is too supported for above scenerio. Regards -Manish

Log shipping is a SQL thing, not a SCOM thing. Log shipping is supported in SQL 2008 R2. Regards, Marc Klaver http://jama00.wordpress.com/

Hi, As far as I know, SQL Server 2008 R2 supports this feature as well. For more information, please also refer to: Log Shipping http://msdn.microsoft.com/en-us/library/bb895393.aspx Thanks. Nicholas Li - MSFT Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi, As far as I know, SQL Server 2008 R2 supports this feature as well. For more information, please also refer to: Log Shipping http://msdn.microsoft.com/en-us/library/bb895393.aspx Thanks. Nicholas Li - MSFT Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.