Moving the Configuration Management Database - CMDB - from one SQL Server to another

book

Article ID: 184917

calendar_today

Updated On:

Products

Symantec Products

Issue/Introduction

Due to either space constraints or performance issues, The IT Management Suite (ITMS) Configuration Management Database (CMDB) needs to be moved to a new SQL Server.

Environment

ITMS 8.1 and 8.5

Resolution

Disclaimer: The following steps are provided as reference. Questions or concerns or for more details about how to migrate a database from a SQL Server, please contact Microsoft. 

Note: Login to all servers, SMP, Current SQL and New SQL servers using the Account used to install the SMP! This will maintain correct ownership of the database when exported and maintain alignment on the import.

The following solution involves several steps:

  1. Pre-move check on the destination SQL Server
  2. Backup the Configuration Management Database (CMDB)
  3. Backup of the KMS keys on the source server
  4. Restoring the Configuration Management Database
  5. Verify the permissions of the CMDB
  6. Change the database location referenced by the Management Platform

       Note: Symantec Management Platform 8.1 does not allow a database change in console, please use the Symantec Installation Manager.
       See the details below.

I. Pre-move check on the destination SQL Server

  1. Verify that the SQL Server version, service pack and edition are supported by the Symantec Management Platform.
  2. Verify that the Symantec_CMDB database collation matches the destination SQL Server collation.

Symantec_CMDB database collation will be in the database properties. SQL Server collation will be in the SQL Server instance properties.
The Following SQL Query can also show the master database (SQL Server instance) and user database collation.

      select sdb.name ,sdb.collation_name from sys.databases as sdb

The master database collation must match the Symantec_CMDB database collation to avoid a collation conflict.

  1. Backup the Symantec Management Platform server following the steps from the IT Management Suite Disaster Recovery White Paper.
     

II.  Backup the Configuration Management Database (CMDB)

  1. Open Microsoft SQL Manager Studio.
  2. In the left pane, expand the Databases folder.
  3. In the left pane, under Databases, right-click the name of your database.
  4. In the right-click menu, click Tasks > Back Up.
  5. In the Backup Database dialog box, in the Backup type drop-down list, click Full.
  6. In the Backup set section, enter a name for your backup.
  7. In the Destination section, add the location where you want your backup file to be stored.
  8. This location should be a secure storage location, and should not be on the local computer.
  9. Click OK.

III.  Backup of the KMS keys on the source server.

  1. Login to the Notification Server
  2. Open the Symantec Installation Manager (SIM).
  3. Select "Repair Installed Products"
  4. For Symantec Installation Manager (SIM) 8.0 - 8.1
    1. Select the backup location desired and enter a password.
    2. "Select Perform backup"
    3. Select "Manage KMS keys", click "Next >"
    4. Click "Backup".
  5. For Symantec Installation Manager (SIM) 8.5
    1. Select "Back up or restore Notification Server configuration" and make a backup of your KMS keys. See "IT Management Suite 8.5 Disaster Recovery White Paper" for information on how to accomplish this step.
    2. Select the backup location desired and enter a password.
      1. NOTE: "Encryption password must be non-empty and its minimum length is four symbols. It must contain symbols corresponding to three of four categories: upper- and lower-case letters, digits and special characters."
    3. Click "Backup".
      1. The window showing backup files may be blank until the backup is completed and then it will populate with the file you just created.
      2. NOTE: This version of SIM can open KMS files from previous versions.
  6. A pop-up window will display the status of the backup
    1. If successful, click OK on the KMS backup screen and return to return to SIM.
    2. Click "Close" to return to the main screen of SIM

IV.  Restoring the Configuration Management Database

  1. Open Microsoft SQL Manager Studio.
  2. In the left pane, on the right-click menu of the Databases folder, click Restore Database.
  3. In the Restore Database dialog box, click From device.
  4. Click the ellipsis option that is associated with the From device option that lets you select the database.
  5. In the Specify Backup dialog box, click Add.
  6. In the Locate Backup File dialog box, select the CMDB that you backed up on the Symantec Management Platform 7.0 server, and click OK.
  7. In the Specify Backup dialog box, click OK.
  8. In the Restore Database dialog box, in To database, enter a name for the database, select the database in the Select the backup sets to restore section, and click OK.
  9. After the database is restored, click OK in the dialog box that appears.

V.  Setting the appropriate permissions to the SQL database

  1. When you restore the Configuration Management Database (CMDB) on a new server, you must set the appropriate permissions to the SQL database. If you use application permissions to access SQL in Symantec Installation Manager, you must give the application account database ownership (DBO). If you use a specific SQL account to access SQL in Symantec Installation Manager, you must give that account DBO.
  2. To set the appropriate permissions to the SQL database
  3. Open Microsoft SQL Manager Studio.
  4. In the left pane, under the Databases folder, on the right-click menu of the CMDB, click Properties.
  5. In the Database Properties dialog box, in the Select a page section, click Files.
  6. In the right pane of the Database Properties dialog box, click the ellipsis option that is associated with the Owner option.
  7. In the Select Database Owner dialog box, click Browse.
  8. In the Browse for Objects dialog box, select the appropriate account and click OK.
  9. In the Select Database Owner dialog box, click OK.
  10. In the Database Properties dialog box, click OK.
     

VI.  Symantec Management Platform 8.1 and newer

  1. Logon to the Management Platform Server with the application service account (Altiris Service).
  2. Start the Symantec Installation Manager.
  3. Configure settings> Configure Database Settings, Next.
  4. Change the SQL Server/Instance name to the new server with the moved Symantec_CMDB database.
  5. Select the correct Symantec_CMDB database and press Next.
  6. When the database is selected, it will prompt for the KMS key zip file from Step III, enter the location for the key zip file from the new target server.