Versions Compared

Old Version 49

changes.mady.by.user Alejandra Rivera

Saved on

compared with

New Version 50

changes.mady.by.user Alejandra Rivera

Saved on

Key

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

8.5.2 New Features

Backup

  • The SQL Safe Management Console has been improved to allow users to perform backups in native (.bak) format.

IDERA Dashboard

  • SQL Safe Backup is now integrated with IDERA Dashboard 4.6.0.9.

SQL Safe Web Console

  • The SQL Safe Web Console includes an additional tab named Advanced for editing properties of a registered instance.

8.5.2 Fixed Issues

Availability Groups

  • Status
    colourGreen
    titleSQLSAFE-13888
     Users can now perform Full/Differential backups on the secondary replica and Full/Differential policies on the primary replica.

Backup

  • Status
    colourGreen
    titleSQLSAFE-12892
     The verify bakcup option is now working properly when performing backups to TSM.
  • Status
    colourGreen
    titleSQLSAFE-13438
     Users can now backup large databases to Amazon S3.
  • Status
    colourGreen
    titleSQLSAFE-13521
     Scheduled backup jobs are now working properly in a failover cluster environment.
  • Status
    colourGreen
    titleSQLSAFE-13938
     Users can now perform backups with a remote instance using a non-default port number.
  • Status
    colourGreen
    titleSQLSAFE-13908
     Improved user experience with T-Log backup operations.

Cluster Environment

  • Status
    colourGreen
    titleSQLSAFE-13875
     Users can now deploy the Backup Agent onto a Cluster Environment from the SQL Safe Management Console.

Desktop Console

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

Grooming

  • Status
    colourGreen
    titleSQLSAFE-12842
     The repository grooming is now set to 365 days.
  • Status
    colourGreen
    titleSQLSAFE-13854
     The grooming bitesize option is now set to 1000.

Installation

  • Status
    colourGreen
    titleSQLSAFE-13984
     The recovery model and page verify settings are now set properly when installing SQL Safe Backup.

License

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

Management Service

  • Status
    colourGreen
    titleSQLSAFE-12850
     Log entries are now working properly.

Policies

  • Status
    colourGreen
    titleSQLSAFE-9560
     Restore policies are now working properly when changing the target database name of a restore performed from one server to another.
  • Status
    colourGreen
    titleSQLSAFE-13406
     The Copy Policy feature is now scheduling policies properly.
  • Status
    colourGreen
    titleSQLSAFE-14060
     When performing a backup policy, the location type is now set properly.

Restore

  • Status
    colourGreen
    titleSQLSAFE-13903
     Users can now restore backup files that are moved manually to Amazon S3. Once the file is moved to Amazon S3, rename the file, and perform the restore.
  • Status
    colourGreen
    titleSQLSAFE-13938
     Users can now perform restores with a remote instance using a non-default port number.

T-Log Backup

  • Status
    colourGreen
    titleSQLSAFE-13908
     Improved user experience with T-Log backup operations.

Upgrade

  • Status
    colourGreen
    titleSQLSAFE-13976
     Users can now upgrade manually SQL Safe Backup from 8.4.2 to 8.5.2 using the agent. 

8.5.1 New Features

Amazon

  • SQL Safe Backup now supports the Amazon AWS GovCloud S3 in the SQL Safe Management Console and SQL Safe Web Console.

Azure

  • SQL Safe Backup now supports the Azure Government Blob Storage in the SQL Safe Management Console, SQL Safe Web Console, SQL Safe CLI, and SQL Safe XSP.

Tivoli Storage Manager (TSM)

  • SQL Safe Backup now allows users to create striped files when backing up to TSM through the SQL Safe Management Console.

8.5.1 Fixed Issues

Access Files

  • Status
    colourGreen
    titleSQLSAFE-13737
     The SQL Safe Web Console will now prompt users for credentials to access the file system when the initial attempt fails.

Backup

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

  • Status
    colourGreen
    titleSQLSAFE-12893
    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 a 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.

Instant Restore

  • Status
    colourGreen
    titleSQLSAFE-9722
     Resolved an issue that would prevent an InstantRestore operation from completing successfully.

Management Console Preferences

  • Status
    colourGreen
    titleSQLSAFE-13350
     The preferences set on either the SQL Safe Web Console or SQL Safe Management Console are kept the same when performing operations.
  • Status
    colourGreen
    titleSQLSAFE-13891
     Users can now set long passwords for the deployed Backup Agents service account in the Agent Deployment option.
  • Status
    colourGreen
    titleSQLSAFE-13842
     The SQL Safe Management Console is no longer reporting a false failure when deploying the SQL Safe Backup Agent to a remote server.

Object Level Recovery

  • Status
    colourGreen
    titleSQLSAFE-13577
     Users can now perform Object Level Recovery operations to a large backup file.

Operation History

  • Status
    colourGreen
    titleSQLSAFE-13137
     The Database name of every operation performed is kept in the Operation History tab.
  • Status
    colourGreen
    titleSQLSAFE-12154
     The SQL Safe Web Console now displays times in the local time zone.

Policies

  • Status
    colourGreen
    titleSQLSAFE-13848
     Users can now edit SQL Safe Backup Policies which includes unreachable SQL Server instances and/or SQL Safe Backup Agents.

Repository

  • Status
    colourGreen
    titleSQLSAFE-11932
     Improvements to the grooming operation.

Restore

  • Status
    colourGreen
    titleSQLSAFE-13489
     Optimized the mc_GetRestorableDatabaseBackupsets stored procedure which is used to populate the list of backup sets in the SQL Safe Restore wizard.
  • Status
    colourGreen
    titleSQLSAFE-13839
     SQL Safe Backup can now successfully restore large backup files that are stored in an Amazon S3 bucket.

SQL Safe Backup Service

  • Status
    colourGreen
    titleSQLSAFE-13804
     Optimized the SQL Safe Backup Agent to prevent crashes in certain scenarios.

SQL Safe Management Console

  • Status
    colourGreen
    titleSQLSAFE-13893
     The SQL Safe Management Console is now able to connect to the SQL Safe Management Service without any problems.

SQL Safe Scripts

  • Status
    colourGreen
    titleSQLSAFE-12867
     Removed the 3200 character limit when performing an operation through SQL Safe Backup.

SQL Safe XSP

  • Status
    colourGreen
    titleSQLSAFE-12465
     Users can now perform Object Level Recovery operations using the XSP commands.

8.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

  • Status
    colourGreen
    titleSQLSAFE-13282
     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.
  • Status
    colourGreen
    titleSQLSAFE-13280
     In the SQL Safe Web Console, the user list in Manager Users is now viewable when the list spans several pages.
  • Status
    colourGreen
    titleSQLSAFE-13274
     In the SQL Safe Web Console, users are now able to Add Groups in the Manage Users option.
  • Status
    colourGreen
    titleSQLSAFE-13228
     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

  • Status
    colourGreen
    titleSQLSAFE-11993
     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

  • Status
    colourGreen
    titleSQLSAFE-13351
     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

  • Status
    colourGreen
    titleSQLSAFE-1620
     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

  • Status
    colourGreen
    titleSQLSAFE-13483
     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

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

Operation History

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

Point in Time

  • Status
    colourGreen
    titleSQLSAFE-13560
     The point in time functionality is working properly when mounting a virtual database.

Policies

  • Status
    colourGreen
    titleSQLSAFE-13366
     Users can now add a database to an existing backup policy.
  • Status
    colourGreen
    titleSQLSAFE-13304
     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.
  • Status
    colourGreen
    titleSQLSAFE-13194
     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.
  • Status
    colourGreen
    titleSQLSAFE-13191
     When creating or editing a policy in the SQL Safe Web Console, the credentials specified for accessing the file system is now properly applied. 
  • Status
    colourGreen
    titleSQLSAFE-13159
     In the SQL Safe Web Console, users can run now a policy manually.
  • Status
    colourGreen
    titleSQLSAFE-12673
     In the SQL Safe Web Console, restore policies are working properly when configured to connect to the SQL instance using SQL Server Authentication.
  • Status
    colourGreen
    titleSQLSAFE-13513
     Users can now supply a UNC path when creating or modifying a policy in the SQL Safe Web Console.

Restore

  • Status
    colourGreen
    titleSQLSAFE-13448
     In the SQL Safe Web Console, users can now perform the verify operation using the restore wizard.
  • Status
    colourGreen
    titleSQLSAFE-13372
     In the SQL Safe Web Console, the point in time selection is working properly now in the restore wizard.
  • Status
    colourGreen
    titleSQLSAFE-13173
     In the SQL Safe Web Console, users are now able to select multiple files for restore through the File System and Target Server options.
  • Status
    colourGreen
    titleSQLSAFE-12860
     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.
  • Status
    colourGreen
    titleSQLSAFE-12049
     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

  • Status
    colourGreen
    titleSQLSAFE-12858
     Users can now successfully install SQL Safe Backup while using quotes (") in their service account passwords.

Upgrade

  • Status
    colourGreen
    titleSQLSAFE-13243
     Upgrading will use the existing installation directory rather than using the default path of C:\Program Files\Idera\SQLsafe.
  • Status
    colourGreen
    titleSQLSAFE-12574
     The SQL Safe Agent Components can now be upgraded through the SQL Safe Management Console.

8.4.2 Fixed Issues

Dashboard

...