SQL Defrag Manager 2.0 and later support seamless integration and communications between trusted and non-trusted domains. If you want to take advantage of this feature, use the following instructions to upgrade your SQL Defrag Manager 2.0 or earlier environment.

To upgrade SQL Defrag Manager 2.0 or later to the current release version, follow the standard Typical or Staged upgrade instructions.

Upgrading an island deployment

This deployment consists of:

  • A complete SQL Defrag Manager installation in each non-trusted domain
  • A single centralized installation that manages SQL Server instances in your trusted domain

If you use remote consoles, you must upgrade the Management Service and Repository before you upgrade the remote consoles.

To upgrade this deployment:

  1. Decide how many SQL Defrag Manager Consoles you need to keep in each domain. Maintaining a Management Console in a non-trusted domain is not required.
  2. Identify which domain you want to host your new centralized SQL Defrag Manager deployment.
  3. Ensure your Management Service account has the appropriate permissions.
  4. Uninstall the SQL Defrag Manager components from the domains you do not intend to use to host SQL Defrag Manager. Remember to preserve the Management Consoles you identified in Step 1.
  5. Upgrade the SQL Defrag Manager management components that were previously deployed to the selected domain.
  6. Run the setup program to upgrade all remaining Management Consoles.
  7. If you use policies to automate your defragmentation operation, start the SQL Defrag Manager Console to synchronize the jobs associated with each policy. This synchronization should happen automatically.
  8. In each Management Console, verify that:
    • It can connect to the upgraded SQL Defrag Manager Repository
    • It is using the correct Management Service



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal


  • No labels