How to migrate OpsMgr to SQL Server 2008 R2


In the last couple of weeks I had to plan the migration of our OpsMgr infrastructure to brand new systems, at the same time, since Cumulative Update 4 adds support for upgrading the OpsMgr database to SQL Server 2008 R2 I wanted to add such a migration as well.

While there are many source of information for such a migration I found there’s no definitive guide for this double hop: the Technet articles still reference SQL 2008 and knowledge base articles just take into account one side or another of the migration.

Proceeding with cut and paste from Technet articles and adding our own experience I managed to build a complete guide for such an upgrade, with two pluses to standard documentation (immo):

  1. ability to migrate custom reports and scheduled reports
  2. disk space and migration time reduction avoiding the backup and restore operations in favor of a copy / attach action

Since the guide is pretty long I link it in pdf format: Unofficial Guide to SQL 2008 R2 Upgrade.

The guide has been tested in our lab and then in our production environment with success. Obviously every environment is different, use it with a grain of salt at your own risk. 

– Daniele

This posting is provided "AS IS" with no warranties, and confers no rights.

Advertisements
  1. Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: