Page History

SQL Safe provides the following new features and fixed issues.

8.

...

Dashboard

• In the Operation History tab, users can now use the Virtual Database filter.

E-mail

• Users can now receive e-mail notifications for Backup/Restore operations performed from the SQL Safe Web Console.

• Users can now update e-mail settings within the IDERA Dashboard.

Licensing

• Updated licensing files that will affect expiring subscription keys (license keys that have an expiration date). If applying a new subscription license key, you must upgrade prior to applying the new key. Perpetual license keys (non-expiring license keys) are not impacted.

Object Level Recovery

• Object Level Recovery Restore Operations are no longer generating the "An item with the same key has already been added" error.

Policies

• When creating/editing a policy through the IDERA Dashboard, users can now set an account for file system access without any problem.

SQL Safe Installation

• When installing SQL Safe, the "Log on as a service" rights are now granted to the accounts specified for the SQL Safe services.

• The installation of SQL Safe is no longer checking for an existing installation of .NET Framework 2.0 as SQL Safe requires an installation of .NET Framework 4.0 or higher.

SQL Safe Re-registration 

• Users can now register SQL Safe with the IDERA Dashboard (Dashboard > Administration > Manage Products > Register a Product).

Virtual Database

• Users can mount a virtual database from backup file(s) located on a UNC share, as long as the SQL Safe Backup Service and SQL Safe OLR Service has permissions to the UNC share.

• Mount Operations through the SQLvdb CLI Commands now recognizes the default location settings in the Graphical User Interface (GUI) and do not require the -Move parameter for the database file.

8.4 New Features

Native Backups

• SQL Safe supports SQL Server native backup format for backups along with the ability to restore from native backups.

Virtual Database

• Virtual Database (VDB) is integrated to SQL Safe 8.4.

8.4 Fixed Issues

Add Instances

• When adding an instance to SQL Safe, users can now validate the entered credentials by running Test Credentials button.

Backup Policy

• Users can select databases when adding all instances in the Backup Policy Wizard.

Backup Policy Schedule

• SQL Safe Backup policies configured with the "Monitor + Automatically create backup jobs using the SQLsafe Backup Agent" action, are now running all operations as scheduled.

Cloud Instances

• All Azure restore operations are recorded and displayed in the Operation History tab.

Encrypted Backup

• Users are no longer prevented from completing the SQL Safe Backup Wizard when selecting the "Backup with different options" setting on a backup operation that was previously completed which resulted in an encrypted backup file.

License

• The IDERA Dashboard now displays the SQL Safe License Key information.

Operation History

• Selecting the “Backup with different options” option in the Operation History tab no longer generates exceptions.

Restore Database

• In the Restore Database wizard, the browse button, located in the Databases option under File System tab, is now enabled.

• In the SQL Safe Restore Wizard, selecting a file path using the Browse feature correctly populates the file path that was chosen.

SQL Safe Backup Service

• The installation or the upgrade of the remote SQL Safe Backup Agent service is no longer displaying errors.

SQL Safe Product Migration

• SQL Safe product migration on CWF is no longer an issue.

SafeToSQL Utility

• SafeToSQL Utility can convert .safe backups into .bak backups and it is no longer having .NET versions conflicts.

Virtual Database

5 New Features

Grooming

• The groom settings for SQL Safe Backup have been improved to allow users to granularly control the amount of operational history that is to be maintained by SQL Safe Backup. This improvement will provide users with more control on maintaining the size of the SQL Safe repository database.

IDERA Dashboard

• SQL Safe is now integrated with IDERA Dashboard 3.8.1.9.

New Installer

• The installer has been improved to allow the installation of all SQL Safe Backup components and the IDERA Dashboard in one single wizard.

SQL Safe Agents view

• The SQL Safe Agents tab now includes SQL Virtual Database properties.

Support

• SQL Safe now supports SQL Server 2017 CU4+ on a Windows operating system.

Virtual Database

• The Virtual Database page has been updated to allow users to easily manage the virtual databases that have been mounted. Users can quickly and easily identify which virtual databases are mounted on which SQL Server instance.

8.5 Fixed Issues

Administration

• In the SQL Safe Web Console, users are now able to select the account type and specify the session timeout for the account they are adding in the Manage Users option.
• In the SQL Safe Web Console, the user list in Manager Users is now viewable when the list spans several pages.
• In the SQL Safe Web Console, users are now able to Add Groups in the Manage Users option.
• In the SQL Safe Web Console, users can successfully configure the credentials to be used by the SQL Safe Management Service when connecting to the SQL Safe repository database.

Availability Group

• SQL Safe Backup Policies which include databases in an availability group are now accurately reporting the Backups did not start as scheduled status.

CLI Commands

• Users can now use the CLI commands for "restorelast" and “xp_ss_restorelast” to restore the latest backup without an associated backup policy.

Event Logs

• The SQL Safe Backup Service, by default, is no longer writing entries into the Windows Application Event log when policies are configured to have jobs created by the SQL Safe Backup Agent.

IDERA Dashboard

• In the SQL Safe Web Console, users are now able to perform backup operations successfully where the target location uses a UNC path.

Object Level Recovery

• The Object Level Recovery functionality is working properly now when the repository is hosted on SQL Server 2014+ instance.

Operation History

• In the SQL Safe Web Console, the instance column is now displaying the full instance name on the Operational History page.

Point in Time

• The point in time functionality is working properly when mounting a virtual database.

Policies

• Users can now add a database to an existing backup policy.
• In the SQL Safe Web Console, the filename is now auto-generated when enabling the option to delete backup files in the backup policy wizard.
• In the SQL Safe Web Console, the "Access Files As" option is now able to switch to default state after providing different credentials in Restore policy.
• When creating or editing a policy in the SQL Safe Web Console, the credentials specified for accessing the file system is now properly applied. 
• In the SQL Safe Web Console, users can run now a policy manually.
• In the SQL Safe Web Console, restore policies are working properly when configured to connect to the SQL instance using SQL Server Authentication.
• Users can now supply a UNC path when creating or modifying a policy in the SQL Safe Web Console.

Restore

• In the SQL Safe Web Console, users can now perform the verify operation using the restore wizard.
• In the SQL Safe Web Console, the point in time selection is working properly now in the restore wizard.
• In the SQL Safe Web Console, users are now able to select multiple files for restore through the File System and Target Server options.
• The restore wizard now correctly selects the SQL Server instance based on the user selection on the Databases tab when the Repository option is selected.
• The restore wizard now displays the list of instances in a sorted order on the Databases tab when the Repository option is selected.

SQL Safe installation

• Users can now succesfully install SQL Safe Buckup while using quotes (") in their service account passwords.

Upgrade

• Upgrading will use the existing installation directory rather than using the default path of C:\Program Files\Idera\SQLsafe.
• The SQL Safe Agent Components can now be upgraded through the SQL Safe Management ConsoleThe servers that have SQL Safe Agents installed (Version 8.0.0.423) are no longer reporting “SQLvdb Filter Service version 8.0.0.423: License has expired”.

...