Use a staged process to upgrade your SQL Safe Backup installation if you have a distributed environment, have deployed multiple Backup Agents that cannot be upgraded during the same time period, or you need to adhere to change control policies.
What is a distributed environment?
A distributed environment consists of the SQL Safe 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 will depend 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 environment meets the following conditions:
- The SQL Safe Backup components are installed on different computers
- All Backup Agents are version 5.0 or earlier
To perform a staged upgrade:
- Upgrade the Management Service and Repository database to the newest version of SQL Safe Backup by using the setup program to perform a Custom install.
- Upgrade your Management Console installations to the newest version of SQL Safe Backup. Although you can upgrade the Management Console installations over time, keep in mind that 5.0 and earlier Management Consoles should not be used with the latest version of the Backup Agents.
- If you use policies to automate your backup and restore operations, start the SQL Safe Management Console to synchronize the jobs associated with each policy. This synchronization should happen automatically.
- Upgrade deployed Backup Agents according to your change control policies. As you upgrade your Backup Agents, ensure you use a matching version of the Management Console to manage the corresponding instances and Backup Policies.