Upgrading SQL Safe Backup allows you to take advantage of the new features available in this version.
The backup file names using the %timestamp% macro may change and cause issues with your backup files. This issue only affects some users. For more information, see the known issues section of the Release Notes.
SQL Safe Backup includes a file system filter driver to support the InstantRestore feature. The driver, named SQLsafeFilterDriver, allows SQL Server to access database data while SQL Safe is executing InstantRestore. The driver is only used during this action and is no longer in use once the database is completely hydrated.
Upgrade checklist
To successfully upgrade your Microsoft SQL Server environment to this build, complete the procedures outlined in the following table. These procedures support upgrades from SQL Safe Backup versions 5.0 or later.
| Follow these steps... |
| Ensure the computers on which you want to upgrade SQL Safe Backup meet or exceed the product requirements for this version of SQL Safe Backup. For example, ensure .NET Framework 4.0 or later is running on the target computer. |
| Ensure your Windows logon account has local administrator permissions on the computers you intend to upgrade. |
| Review the Product components and architecture. |
| Review the Supported installation scenarios. |
| Close all open applications on the computers you intend to upgrade. |
|
Available upgrade paths
Because each component can be installed separately on different computers, the type of upgrade you will need to perform will depend on your environment. The following table describes the conditions under which you would follow a typical or staged upgrade path.
| Environment Description | Recommended Path | Why |
|---|---|---|
Simple environment, where the Management Console, the Repository, and the Management Service all reside on the same computer. | Typical | A simple environment can be upgraded through the setup program. |
Distributed environment, where each SQL Safe Backup component resides on a different computer. | A distributed environment requires a staged upgrade to maintain backup continuity while each component is upgraded. | |
Multiple Management Consoles deployed to different computers. | A SQL Safe Backup installation with multiple Management Consoles requires a staged upgrade in order to maintain connection with all Backup Agents while each component is upgraded. | |
Backup Agents from different SQL Safe Backup versions. | An environment that manages Backup Agents from different SQL Safe Backup versions requires a staged upgrade in order to maintain connection with all Backup Agents while each component is upgraded. | |
Change control policies that require multi-phased upgrades. | An environment with stringent change control policies requires a multi-phased upgrade in order to test each updated component thoroughly before moving on to the next step. |
For more information, see available upgrade paths.
New encryption options in 6.0 and later
SQL Safe Backup 6.0 and later provides new, more secure encryption algorithms. To use these new algorithms, upgrade your Backup Agents to the latest version.
| Previous Encryption Options | SQL Safe 6.x Encryption Options |
|---|---|
AES DES Triple-DES RC2 | AES-128 AES-256 |
These new encryption options replace the options previously available in SQL Safe Backup 5.0 or earlier. You can select the new encryption options when you manually perform a backup, or create and edit existing Backup Policies.
If you had set encryption options when creating your Backup Policies, the encryption method specified in the corresponding SQL Server job will be automatically updated to AES-128 when you upgrade the associated Backup Agent. You can later change this setting by editing the policy.
SQL Safe Backup 6.0 and later does support previously encrypted archives; you can continue to restore any encrypted backup file created with a previous version of SQL Safe.
More upgrade paths
- To upgrade the SQL Safe Management Components, review the Installing SQL Safe Backup and IDERA Dashboard.
- To upgrade the Backup Agents, visit Upgrade deployed Backup Agents.
- To upgrade SQL Safe Backup in non-trusted domains, see Upgrade SQL Safe Backup in non-trusted domains.
- To upgrade SQL Safe Backup when your SQL Server is running SQL Safe Lite or SQL Safe Freeware edition, see Upgrade the Lite or Freeware Edition or Upgrade the SQL Safe Freeware Edition.
- To upgrade SQL Safe Backup in a clustered environment, see Upgrade backup/restore components in a clustered environment.
SQL Safe is ONLY compatible with IDERA Dashboard version 4.6 and with limited support.