Use a staged process to upgrade your SQL defrag manager installation if you have a distributed environment or you need to adhere to change control policies.
What is a distributed environment?
A distributed environment consists of the SQL defrag manager management components running on different physical computers. The management components are:
- Repository database
- Management Service
- Management Console
The time scale over which you choose to perform a staged upgrade depends on the size of your SQL Server environment and your corporate change control policies. For example, you may choose to perform one of the following steps per day or per week; however, the order in which you perform them should remain the same.
How to perform a staged upgrade
Use this process if your SQL defrag manager components are installed on different computers.
To perform a staged upgrade:
- Upgrade the Management Service and Repository database to version 3.1 by using the setup program to perform a Custom install.
- Upgrade your Management Console installations to version 3.1.
- 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.