AD RMS Database Relocation without a CNAME Record - Step-by-Step

Updated: March 19, 2013

Applies To: Windows Server 2008, Windows Server 2008 R2, Windows Server 2012

Authored By: Bill Mathers

About this Guide

This step-by-step guide walks you through the process of moving the AD RMS databases from one SQL Server 2008 SP1 server to another SQL Server 2008 SP1 server. This is done in a test environment so that you may be familiar with the process before attempting it in a production environment. The first part of this guide deals with setting up a working AD RMS test environment. It is this environment that will be used to verify that the databases have been moved successfully. The final parts of this guide deal with the actual moving of the databases.

As you complete the steps in this guide, you will:

  • Backup the AD RMS database.

  • Restore the AD RMS database.

  • Verify that the move was successful and that AD RMS is up and running again. This is done by testing the ability to create new rights-protected content once the databases have been moved, consume the newly created rights-protected content, and consume existing rights-protected content.

What This Guide Does Not Provide

This guide does not provide the following:

  • Guidance for setting up and configuring Active Directory Domain Service in either a production or test environment. This guide assumes that Active Directory Domain Services is already configured in the test environment. For more information about configuring Active Directory Domain Services see, AD DS Installation and Removal Step-by-Step Guide (https://go.microsoft.com/fwlink/?LinkId=154567).

  • Guidance for setting up and configuring Active Directory Certificate Services in either a production or test environment. This guide assumes that Active Directory Certificate Services is already configured and working in the test environment. You must ensure that you have a valid SSL certificate and that it is bound properly in IIS to the default website. For more information about configuring Active Directory Certificate Services, see the Active Directory Certificate Services (https://go.microsoft.com/fwlink/?LinkId=179761).

  • Guidance for setting up and configuring AD RMS in either a production or test environment. This guide assumes that AD RMS is already configured and working in the test environment. For more information about configuring AD RMS, see the AD RMS Step-by-Step Guide (https://go.microsoft.com/fwlink/?LinkID=154256).

  • Guidance for setting up and configuring Exchange Server 2007 SP1 in either a production or test environment. This guide assumes that Exchange 2007 SP1 is already setup and configured in the test environment. For more information about configuring Exchange Server 2007 SP1, see Microsoft Exchange Server 2007 (https://go.microsoft.com/fwlink/?LinkId=154564).