Chapter 4. Using SQL Server 2008 in OpsMgr 2007 R2

IN THIS CHAPTER

• Core OpsMgr Component Support

• Setup

• Operations Manager 2007 R2 Reporting

• Database Maintenance

• Useful SQL Queries

SQL Server is an integral component of a functional OpsMgr management group. This chapter discusses specifics of installing and upgrading SQL Server 2008 for the System Center Operations Manager (OpsMgr) 2007 Release 2 (R2) environment. The focus is on what’s new when using SQL Server with OpsMgr 2007 R2, including core database support and architectural changes for the OpsMgr Reporting component to work with SQL Server 2008. Also discussed is upgrading a SQL Server 2005 database installation to SQL Server 2008, and database maintenance and optimization ...

Get System Center Operations Manager (OpsMgr) 2007 R2 Unleashed: Supplement to System Center Operations Manager 2007 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial