Yes there is support for SQL 2008 R2 , Soon all products are supported. But remember not all third party’s are ready for SQL 2008 R2.
The support is divided into two phases. Phase one supports new installations of System Center Operations Manager 2007 R2. Phase two supports upgrading an existing System Center Operations Manager 2007 R2 deployment to run on a SQL Server 2008 R2 database. The existing deployment has database roles hosted on a Microsoft SQL Server 2005 Service Pack 3 (SP3) server or on a Microsoft SQL 2008 Service Pack 1 (SP1) server.
There is a great document for SQL 2008 R2 Microsoft SQL Server 2008 R2- The Best Data Platform on Windows Server 2008 R2