Operations Manager R2 now supports OM database roles running on SQL 2008 with SP1. Please be sure install SP1 of SQL 2008 before beginning your R2 install or upgrade. Our Prerequisite checker detects for SQL 2008 SP1and will block until it is found. Note: We still continue to support SQL 2005 with SP1 or higher.
Operations Manager R2 also supports upgrading from SQL 2005 to SQL 2008. Only the Operations Manager Reporting role require special instructions. Detailed instructions can be found in the upgrade guide. Upgrading SQL Server 2005 to SQL Server 2008 Link
Operations Manager supports the following upgrade paths:
For agents that are multi-homed we support the following:
When upgrading from R2 RC to R2 RTM please follow the same procedures outlined in the Upgrade guide for upgrading from OM SP1 to OM R2.
http://technet.microsoft.com/en-us/library/dd362729.aspx
Windows Server 2008 Foundation, WePOS v1, POSReady, Windows Embedded Standard, Windows Embedded Enterprise, Windows Embedded POS Ready
Upgrade Guide
Troubleshooting Guide
Deployment Guide
Note: This information was originally contributed by Rob Kuehfus, Operations Manager Setup and Deployment Program Manager, on the Operations Manager Team blog:
http://blogs.technet.com/momteam/archive/2009/05/29/what-s-new-in-r2-deployment-and-upgrade.aspx
Maheshkumar S Tiwari edited Revision 1. Comment: Added TOC
Maheshkumar S Tiwari edited Original. Comment: Added Tags and Formattting