Page History
SQL Safe Backup provides the following new features and fixed issues.
...
9.
...
2.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.
Restore
- For Restore operations, you can now Prioritize the Operation.
9.2.
...
2 Fixed Issues
Availability GroupsGroup
Users can now perform Full/Differential backups on the secondary replica and Full/Differential policies on the primary replica. You can change the Database Owner for restored databases in Availability Groups.Status colour Green title SQLSAFE-1388815109
InstanceBackup
The verify bakcup option is now working properly when performing backups to TSM.Status colour Green title SQLSAFE-12892 Status colour Green Users can now backup large databases to Amazon S3.title SQLSAFE-13438
Instances are listed in alphabetical order now14031 Status colour Green Scheduled backup jobs are now working properly in a failover cluster environment.title SQLSAFE-13521
Users can now perform backups with a remote instance using a non-default port number.Status colour Green title SQLSAFE-1393813993 Status colour Green Improved user experience with T-Log backup operations.title SQLSAFE-13908
Cluster Environment
- You can register instances with the same name in different domains.
Policy
Users can now deploy the Backup Agent onto a Cluster Environment from the SQL Safe Management Console.Status colour Green title SQLSAFE-13875
The selected options in the wizard are retained when you click back on the wizard.14910
RestoreDesktop Console
The Last Operation Status section is now updating properly the list of backups succeeded and failed. The restore file list provides support for Cloud Storage.Status colour Green title SQLSAFE-1376614676
SQL Safe AgentGrooming
The repository grooming is now set to 365 days.Status colour Green title SQLSAFE-1284214931 Status colour Green The grooming bitesize option is now set to 1000.title SQLSAFE-13854
Installation
...
- The panel Upgrade Status displays now information properly when upgrading the SQL Safe Backup Agent.
SQL Safe Management ConsoleLicense
The license key instance status is now working properly when adding instances displaying the information properly in the Web SQL Safe Management Console.Status colour Green title SQLSAFE-1365215056
Management Service
...
Policies
...
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
...
Restore
...
T-Log Backup
...
Upgrade
...
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
The SQL Safe Web Console will now prompt users for credentials to access the file system when the initial attempt fails.Status colour Green title SQLSAFE-13737
Backup
Full (copy-only) backups are running normally on secondary replicas when the backup preference is set to "Prefer Secondary"14897
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 colour Green title SQLSAFE-13346
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 colour Green title SQLSAFE-12893
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 ConsoleStatus colour Green title SQLSAFE-12894
The Mass Agent Upgrade option works properly using AG Listener and AG Cluster nodes.14976
SQL Safe Backup displays now properly the progress of a backup operations that are being performed without compression.Status colour Green title SQLSAFE-9555
Users can now apply changes to policies involved with Failover Cluster Instances.14906
Virtual Database
Backup and restore operations performed in native file format can have timeout values modified through a registry key update.Status colour Green title SQLSAFE-13892
Percentage values are no longer included in the Result Text of backup and restore operations.Status colour Green title SQLSAFE-13225
Instant Restore
Resolved an issue that would prevent an InstantRestore operation from completing successfully.Status colour Green title SQLSAFE-9722
Management Console Preferences
The preferences set on either the SQL Safe Web Console or SQL Safe Management Console are kept the same when performing operations.Status colour Green title SQLSAFE-13350
Users can now set long passwords for the deployed Backup Agents service account in the Agent Deployment option.Status colour Green title SQLSAFE-13891
The SQL Safe Management Console is no longer reporting a false failure when deploying the SQL Safe Backup Agent to a remote server.Status colour Green title SQLSAFE-13842
Object Level Recovery
Users can now perform Object Level Recovery operations to a large backup file.Status colour Green title SQLSAFE-13577
Operation History
The Database name of every operation performed is kept in the Operation History tab.Status colour Green title SQLSAFE-13137
The SQL Safe Web Console now displays times in the local time zone.Status colour Green title SQLSAFE-12154
Policies
Users can now edit SQL Safe Backup Policies which includes unreachable SQL Server instances and/or SQL Safe Backup Agents.Status colour Green title SQLSAFE-13848
Repository
Improvements to the grooming operation.Status colour Green title SQLSAFE-11932
The issue of restoring virtual databases is solved now.14365
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 CloudRestore
Optimized the mc_GetRestorableDatabaseBackupsets stored procedure which is used to populate the list of backup sets in the SQL Safe Restore wizard.Status colour Green title SQLSAFE-13489
SQL Safe Backup can now successfully restore large backup files that are stored in an Amazon S3 bucket.Status colour Green title SQLSAFE-13839
Restore operations are performed successfully on Amazon Cloud Storage.14621
Availability GroupSQL Safe Backup Service
Optimized the SQL Safe Backup Agent to prevent crashes in certain scenarios.Status colour Green title SQLSAFE-13804
SQL Safe Management Console
The SQL Safe Management Console is now able to connect to the SQL Safe Management Service without any problems.Status colour Green title SQLSAFE-13893
...
The License Key Manager and Repository and Management Service Settings are now identifying and displaying properly the Availability Group Listener Name registered at installation.14534
Removed the 3200 character limit when performing an operation through SQL Safe Backup.Status colour Green title SQLSAFE-12867
SQL Safe XSP
There are no delays when performing simultaneous Backup operations on Availability Group instances.14850
Users can now perform Object Level Recovery operations using the XSP commands.Status colour Green title SQLSAFE-12465
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
The SQL Safe Agent is running properly on the Availability Group listener.14852
Azure Cloud
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 colour Green title SQLSAFE-13282
In the SQL Safe Web Console, the user list in Manager Users is now viewable when the list spans several pages.Status colour Green title SQLSAFE-13280
Restore operations are working properly on Azure Blob Storage.14704
Backup
In the SQL Safe Web Console, users are now able to Add Groups in the Manage Users option.Status colour Green title SQLSAFE-13274 Status colour Green 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.title SQLSAFE-13228
Availability Group
...
The Backup time and compression on TDE-enabled databases are working properly.14820
...
Users can now use the CLI commands for "restorelast" and “xp_ss_restorelast” to restore the latest backup without an associated backup policy.Status colour Green title SQLSAFE-13351
Event Logs
Information about Pre/Post Backup commands is displayed now in the Option section of the Summary tab.14866
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.Status colour Green title SQLSAFE-
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.Status colour Green title SQLSAFE-13483
Object Level Recovery
There is no FileStream error message for any Backup operations performed for any databases.14006
The Object Level Recovery functionality is working properly now when the repository is hosted on SQL Server 2014+ instance.Status colour Green title SQLSAFE-13320
Operation History
In the SQL Safe Web Console, the instance column is now displaying the full instance name on the Operational History page.Status colour Green title SQLSAFE-13254
Point in Time
The Mount VDB and Object Level Recovery operations are now working properly for Differential Backups14684
The point in time functionality is working properly when mounting a virtual database.Status colour Green title SQLSAFE-13560
Policies
13366 Users can now add a database to an existing backup policy.Status colour Green title SQLSAFE-
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 colour Green title SQLSAFE-13304
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 colour Green title SQLSAFE-13194
The Location Path is not altered when changing a Policy compression type.14328
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 colour Green title SQLSAFE-13191
In the SQL Safe Web Console, users can run now a policy manually.Status colour Green title SQLSAFE-13159
In the SQL Safe Web Console, restore policies are working properly when configured to connect to the SQL instance using SQL Server Authentication.Status colour Green title SQLSAFE-12673
Users can now supply a UNC path when creating or modifying a policy in the SQL Safe Web Console.Status colour Green title SQLSAFE-13513
Users can now edit successfully existing policies.14840
SQL Safe Backup/Restore
13448Status colour Green title SQLSAFE-
Users can now perform Backup and Restore operations of more than one backup file from multiple locations In the SQL Safe Web Console, users can now perform the verify operation using the restore wizard.14699
In the SQL Safe Web Console, the point in time selection is working properly now in the restore wizard.Status colour Green title SQLSAFE-13372
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 colour Green title SQLSAFE-13173
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 colour Green title SQLSAFE-12860
The restore wizard now displays the list of instances in a sorted order on the Databases tab when the Repository option is selected.Status colour Green title SQLSAFE-12049
SQL Safe installation
Users can now successfully install SQL Safe Backup while using quotes (") in their service account passwords.Status colour Green title SQLSAFE-12858
Upgrade
Backup and Restore operations are successful with SQL Server Multi-Subnet Clustering13044
Upgrading will use the existing installation directory rather than using the default path of C:\Program Files\Idera\SQLsafe.Status colour Green title SQLSAFE-13243
The SQL Safe Agent Components can now be upgraded through the SQL Safe Management Console.Status colour Green title SQLSAFE-12574