Only SQL 2008 SP1 is supported on Windows 2008 R2. If you tried installing SQL 2008 from its DVD\ISO you surely got this error message: In order to install SQL 2008 together with SP1, follow these Steps: Install the prerequisites of SQL 2008: .NET Framework 3.5 SP1 (from Server Manager –> Features –> .Net Framework
Upgrading to SCOM R2 when using a remote SQL server
Please pay attention to the following guidelines: Uninstall the SCOM SP1 agent from the SQL server before upgrading your RMS To speed up the upgrade process, run the following query using SQL Management Studio: use OperationsManager exec sp_updatestats DBCC FREEPROCCACHE Make sure the OperationsManager DB is configure to accept updates using the following command: exec
Hyper-V & SQL consolidation at Microsoft IT
A new white paper has been published that compares the options to use multiple instances of SQL without Hyper-V with having multiple virtual machines with single instances of SQL Server. Not only it looks at the different pros and cons, but also provides interesting performance information. Here’s are the topics covered in this 26-page white
Creating Custom Reports By Using Configuration Manager 2007 SQL Views
Microsoft has released a new document to help you create custom reports. You can download it here. Overview Microsoft System Center Configuration Manager 2007 queries SQL Server views in the Configuration Manager site database when retrieving the information displayed in reports. The Configuration Manager site SQL database contains a large collection of information about the
Presentations from the System Center Round Table for Enterprise Clients
As promised, I’ve uploaded the presentations from the sessions I gave on December 18th at Microsoft Israel. Enjoy. Physical And Virtual Server Management Deploying Windows With Configuration Manager 2007 R2 Data Protection Manager 2007 Dynamic Server Provisioning With Ops Manager And Hyper V ? Notes From The Field
Data Protection Manager SP1
SP 1 for System Center Data Protection Manager 2007 will be available on December 8th 2008. Along with the roll up update this release enhances many of the core features of DPM 2007. The key among them being Protection of Hyper-V? virtualization platforms Enhanced SQL Server 2008 protection Microsoft Office SharePoint Server 2007 and Windows
Microsoft Assessment and Planning Toolkit 3.2 RTM Version Now Available!
MAP is a scalable and agent-less assessment platform designed to make it easier for you to adopt the latest Microsoft technologies. In this version, MAP has expanded its assessment capabilities to include SQL Server 2008, Forefront/NAP, and Microsoft Online Services migration, as well as providing a Power Savings assessment to help you "go green." In
Running SQL Server in Hyper-V Environment: Best Practices and Recommendations
Based on hypervisor technology, the Hyper-V™ virtualization feature in the Windows Server® 2008 operating system is a thin layer of software between the hardware and the operating system that allows multiple operating systems to run, unmodified, on a host computer at the same time. Hyper-V is a powerful virtualization technology that can be used by
SCOM 2007 On-Demand Webcasts
How Microsoft IT Implements System Center Operations Manager 2007 (Level 300) http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?culture=en-US&EventID=1032322478&CountryCode=US Assure the Availability and Performance of Your SharePoint Environments (Level 300) http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032368298&EventCategory=4&culture=en-US&CountryCode=US Client Monitoring with System Center Operations Manager 2007 (Level 300) http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032348673&EventCategory=4&culture=en-US&CountryCode=US Client Monitoring with System Center Operations Manager 2007 (Level 200) http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032341228&EventCategory=4&culture=en-US&CountryCode=US Client Monitoring with System Center Operations Manager 2007 (Level
Important updates regarding SCCM 2007 R2
SQL Server 2008 is now supported on Configuration Manager 2007 RTM and SP1 System Center Configuration Manager 2007 (RTM and SP1) now supports the use of SQL Server 2008 as a site database. In order to upgrade a site-server database to SQL 2008 there are 2 hot fixes required: ConfigMgr 2007 RTM customers must apply
