Versions Compared

Key

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

SQL Safe Backup provides the following new features and fixed issues.

...

9.2.

...

2 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 successfully install SQL Safe Backup 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 Console.

Restore

  • For Restore operations, you can now Prioritize the Operation.

9.2.2 Fixed Issues

Availability Group

  • Status
    colourGreen
    titleSQLSAFE-15109
    You can change the Database Owner for restored databases in Availability Groups.

Instance

  • Status
    colourGreen
    titleSQLSAFE-14031
    Instances are listed in alphabetical order now.
  • Status
    colourGreen
    titleSQLSAFE-13993
    You can register instances with the same name in different domains.

Policy

  • Status
    colourGreen
    titleSQLSAFE-14910
    The selected options in the wizard are retained when you click back on the wizard.

Restore

  • Status
    colourGreen
    titleSQLSAFE-14676
    The restore file list provides support for Cloud Storage.

SQL Safe Agent

  • Status
    colourGreen
    titleSQLSAFE-14931
    The panel Upgrade Status displays now information properly when upgrading the SQL Safe Backup Agent.

SQL Safe Management Console

  • Status
    colourGreen
    titleSQLSAFE-15056
    The instance status is now displaying the information properly in the SQL Safe Management Console.

9.2.1 New Features

Instances

  • Registered instances are now stored centrally for all users.

SQL Safe Agent

  • When upgrading the SQL Safe Agents you can also install the Extended Store Procedure.

SQL Safe Backup Operations

  • Users can perform SQL Safe Backup operations on online and offline databases. Offline databases are shown as 'Skipped' in the Status column of the Operation History panel.

9.2.1 Fixed Issues

Availability Group

  • Status
    colourGreen
    titleSQLSAFE-14897
    Full (copy-only) backups are running normally on secondary replicas when the backup preference is set to "Prefer Secondary".
  • Status
    colourGreen
    titleSQLSAFE-14976
    The Mass Agent Upgrade option works properly using AG Listener and AG Cluster nodes.
  • Status
    colourGreen
    titleSQLSAFE-14906
    Users can now apply changes to policies involved with Failover Cluster Instances.

Virtual Database

  • Status
    colourGreen
    titleSQLSAFE-14365
    The issue of restoring virtual databases is solved now.

9.2 New Features

Amazon S3

  • The On-Premise storage option is now available when performing backup operations.

Instances

  • Users can now move their registered instances from the User Preferences to the SQL Safe Repository.

Policies

  • Users can now Import / Export their policies.

9.2 Fixed Issues

Amazon S3 Cloud

  • Status
    colourGreen
    titleSQLSAFE-14621
    Restore operations are performed successfully on Amazon Cloud Storage.

Availability Group

  • Status
    colourGreen
    titleSQLSAFE-14534
    The License Key Manager and Repository and Management Service Settings are now identifying and displaying properly the Availability Group Listener Name registered at installation.
  • Status
    colourGreen
    titleSQLSAFE-14850
    There are no delays when performing simultaneous Backup operations on Availability Group instances.
  • Status
    colourGreen
    titleSQLSAFE-14852
    The SQL Safe Agent is running properly on the Availability Group listener.

Azure Cloud

  • Status
    colourGreen
    titleSQLSAFE-14704
    Restore operations are working properly on Azure Blob Storage.

Backup

  • Status
    colourGreen
    titleSQLSAFE-14820
    The Backup time and compression on TDE-enabled databases are working properly.
  • Status
    colourGreen
    titleSQLSAFE-14866
    Information about Pre/Post Backup commands is displayed now in the Option section of the Summary tab.
  • Status
    colourGreen
    titleSQLSAFE-14006
    There is no FileStream error message for any Backup operations performed for any databases.
  • Status
    colourGreen
    titleSQLSAFE-14684
    The Mount VDB and Object Level Recovery operations are now working properly for Differential Backups.

Policies

  • Status
    colourGreen
    titleSQLSAFE-14328
    The Location Path is not altered when changing a Policy compression type.
  • Status
    colourGreen
    titleSQLSAFE-14840
    Users can now edit successfully existing policies.

SQL Safe Backup/Restore

  • Status
    colourGreen
    titleSQLSAFE-14699
    Users can now perform Backup and Restore operations of more than one backup file from multiple locations.
  • Status
    colourGreen
    titleSQLSAFE-13044
    Backup and Restore operations are successful with SQL Server Multi-Subnet Clustering.




Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...

SQL Safe  is a high-performance backup and recovery solution for your SQL Servers. Learn more > >

...