Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Note

SQL Safe is ONLY compatible with IDERA Dashboard version 4.6 and with limited support.

9.1 New Features

Azure

  • New Authentication Methods are available: Key and SAS (Shared Access Signature Service URL).

Backup in Desktop Console

  • Users can now run Pre/Post-Backup Commands.

Upgrade

  • A new wizard to upgrade SQL Safe Agents is available.

9.1 Fixed Issues

Amazon S3 Cloud

  • Status
    colourGreen
    titleSQLSAFE-14622
    Restores of backup files with FILESTREAM files are working properly now.
  • Status
    colourGreen
    titleSQLSAFE-14842
    Users can now rename the bucket properly.

Availability Group

  • Status
    colourGreen
    titleSQLSAFE-14341
    Full and Differential backups are working properly on Availability Groups.

Azure Cloud

  • Status
    colourGreen
    titleSQLSAFE-14619
    Backup operations to the Azure Storage account are running faster than before.

Installation

  • Status
    colourGreen
    titleSQLSAFE-13999
    Users can now install remotely the SQL Safe Backup Agent where the Microsoft Visual C++ 2015 redistributable or greater is previously installed.

Object Level Recovery

  • Status
    colourGreen
    titleSQLSAFE-14554
    Object Level Recovery operations on remote instances using CLI or XSP are working properly now.

Policies

  • Status
    colourGreen
    titleSQLSAFE-14393
    Users can now perform log shipping policies properly using CLI with and without encryption.
  • Status
    colourGreen
    titleSQLSAFE-14572
    The SQL Server Agent is working properly when performing backup policies.

Virtual Database

  • Status
    colourGreen
    titleSQLSAFE-14733
    The Virtual Database is mounting the original database.

9.0 New Features

User Interface

  • New User Interface features include UI Scaling (support for 4K monitors and scaled fonts) and a new dark mode theme.

8.7.2 New Features

Amazon S3 Cloud

  • The StorageClass parameter is now available when backing up to Amazon S3 Cloud (AWS S3).

SQL Safe Repository

  • Users can now record the cluster details in the SQL Safe Repository.

8.7.2 Fixed Issues

Azure Cloud

  • Status
    colourGreen
    titleSQLSAFE-14448
    Backup and Restore operations are allowed on Azure File storage and Azure Blob storage.

Backup / Restore

  • Status
    colourGreen
    titleSQLSAFE-13991
    Backup and Restore operations of a database from an Untrusted Domain server are successful.
  • Status
    colourGreen
    titleSQLSAFE-14381
    Backup and Restore operations are allowed from Untrusted Domains.
  • Status
    colourGreen
    titleSQLSAFE-14559
    Backup and Restore operations are working properly on the Amazon S3 cloud.

CLI Command

  • Status
    colourGreen
    titleSQLSAFE-14296
    Restore Policies are working properly through CLI commands for backups in the Amazon S3 cloud.

Instant Restore

  • Status
    colourGreen
    titleSQLSAFE-13868
    Restore Hydration operations can be canceled on the Management Console.

Management Service

  • Status
    colourGreen
    titleSQLSAFE-14268
    The Management Service is working properly.

Object Level Recovery

  • Status
    colourGreen
    titleSQLSAFE-14425
    Reference objects are included in Object Level Recovery operations.

Policies

  • Status
    colourGreen
    titleSQLSAFE-14196
    Backup and Restore policies are working properly for the Azure cloud.
  • Status
    colourGreen
    titleSQLSAFE-14255
    SQL Safe detects when a policy is out of sync.

Restore

  • Status
    colourGreen
    titleSQLSAFE-14265
    The Restore Again option is assigning properly the new path location.

SQL Safe Agent

  • Status
    colourGreen
    titleSQLSAFE-14130
    In untrusted domains, Windows Authentication is blocked and the SQL Safe Agent authenticates using SQL Server Authentication.

Upgrade

  • Status
    colourGreen
    titleSQLSAFE-13889
    Upgrade the repository when the temporary database has been previously backed up. Please contact support for further assistance.
  • Status
    colourGreen
    titleSQLSAFE-14129
    After upgrading SQL Safe Backup, the registration of the Web Console is successful.

Virtual Database

  • Status
    colourGreen
    titleSQLSAFE-14626
    Virtual Database operations are working properly for both local and remote instances.

8.7.1 New Features

Cloud Support

  • Extended support is now available for cloud backups and restores from Azure and Amazon S3.

Desktop Console

  • The user experience has been improved in the Desktop Console.

Object Level Recovery / Virtual Database

  • The Object Level Recovery and Virtual Database functionalities are now refined and reinforced.

8.7.1 Fixed Issues

Backup

  • Status
    colourGreen
    titleSQLSAFE-14526
    Backup files are now deleted from the temporary download location while performing a
    backup.

Cloud Storage

  • Status
    colourGreen
    titleSQLSAFE-14460
    Amazon S3 and Azure cloud storage performance has been improved to load large backup
    files.
  • Status
    colourGreen
    titleSQLSAFE-14264
     
    Status
    colourGreen
    titleSQLSAFE-14513
    Restore operations from Amazon and Azure cloud storage through T-SQL
    and CLI commands are now working properly.

Notifications

  • Status
    colourGreen
    titleSQLSAFE-14132
    Email notifications are sent properly now after the product upgrade.

Operation Status

  • Status
    colourGreen
    titleSQLSAFE-14544
    Queued operations are now displayed correctly in the Operation Status window.

Policies

  • Status
    colourGreen
    titleSQLSAFE-14166
     
    Status
    colourGreen
    titleSQLSAFE-14259
    Status
    colourGreen
    titleSQLSAFE-14280
     
    Status
    colourGreen
    titleSQLSAFE-14500
     
    Status
    colourGreen
    titleSQLSAFE-14562
    Policies performance has
    been improved.

Virtual Database and Object Level Recovery

  • Status
    colourGreen
    titleSQLSAFE-14232
    Virtual Database and Object Level Recovery operations are now supported in a cluster
    environment after a failover.
    Make sure you set up manually the VDBMetadata directory structure before a Virtual Database operation is
    attempted on an availability group environment.

8.7 New Features

Object Level Recovery

  • The Object Level Recovery functionality is now available in the Desktop Console.

Policies

  • Users can now copy policies in the Desktop Console.

Virtual Database

  • The Virtual Database functionality is now available in the Desktop Console.

8.6.1 New Features

Backup and Restore operations

...

  • Status
    colourGreen
    titleSQLSAFE-14267
     Performing a Point-In-Time restore no longer leaves the database in a "recovering" state.

8.6 New Features

...

  • Status
    colourGreen
    titleSQLSAFE-13766
     The Last Operation Status section is now updating properly the list of backups that succeeded and failed.

Grooming

...

  • Status
    colourGreen
    titleSQLSAFE-13652
     The license key is now working properly when adding instances in the Web Console.

...

  • Status
    colourGreen
    titleSQLSAFE-13346
     SQL Safe Backup policies automatically perform a full backup operation when a differential backup operation fails due to a lack of a full backup.

  • Status
    colourGreen
    titleSQLSAFE-12893
    The  The storage options of the Backup again with different options to Tivoli Storage Manager (TSM) are working properly now in the SQL Safe Management Console.
  • Status
    colourGreen
    titleSQLSAFE-12894
     The High Level and Low Level text boxes of the Backup with different options to Tivoli Storage Manager (TSM) are recognizing the data properly in the SQL Safe Web Console.
  • Status
    colourGreen
    titleSQLSAFE-9555
     SQL Safe Backup displays now properly the progress of backup operations that are being performed without compression.
  • Status
    colourGreen
    titleSQLSAFE-13892
     Backup and restore operations performed in native file format can have timeout values modified through a registry key update.
  • Status
    colourGreen
    titleSQLSAFE-13225
     Percentage values are no longer included in the Result Text of backup and restore operations.

...

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

Policies

  • Copying policies is now policies is now available from the Policy tab. Users can now copy preexisting policies and modifying modify their settings before copying them.

...

  • Users do not experience error messages anymore when performing the bulk "Backup Again" operation in the Operation History tab.

  • Users can now sort the databases list of the backup wizard according to Database Name, Last Backup, or Space Used. 

  • The Restore Wizard now updates the point-in-time date accurately after clicking the Apply option. 

  • "Restore again" and "Restore with different options" are now available for Instant Restore operations in the Operation History tab. 

  • Links from "Databases with failed backups" and "Databases with failed restores" in the "My Environment" section of the Home tab now direct to the correct information in the Operation History tab.

  • Users can now access a tool tip tooltip that provides the complete name of SQL Server instances and databases displayed in the bar graphs of the Home tab.

  • SQL Safe now supports TSM (Tivoli Storage Manager) 7.1.1.1.

  • Users can now use wildcards such as %, _, [ ], [^] to find their information more quickly through the filters.

  • Users can now perform the "Restore again" operation as a bulk operation in the Operation History tab without experiencing error messages.

  • When upgrading to a new version, users can now select previous SQL Safe display names or create a new one.

...

  • Administrators and users can now create a backup, restore, and log shipping policies with the same capabilities as in the desktop console. The options for launching the Policy Wizards are available from the Home, Policies, Instances, and Databases tabs.
  • SQL Safe now allows you to access and edit any policy from the Policies tab.  

...

  • Home tab - with a general status of the environment through alerts, summary information of SQL Safe operations, managed instances, and other important data. 

  • Policies tab - with information about all SQL Safe policies existing in the users environment. 

  • Operations History tab - with of all SQL Safe operations performed in the users environment the users environment and their current status.  

  • Instances tab - with a general view of all SQL Server instances registered in the users environment. 

  • Databases tab - with general information of the databases that belong to the SQL Server instances registered in the users environment. 

  • SQL Safe Agents tab - provides information of all computers that host registered SQL Server instances and the details of related Safe Agents. 

...