SQL Safe Backup provides the following new features and fixed issues.
8.
...
6 New Features
BackupAzure / Amazon S3 Cloud
- 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
- SQL Safe Backup 8.6 version now supports Azure and Amazon S3 subfolders.
Cloud Environment
- Redesigned cloud backup and restore operations for Azure and Amazon S3 storage.
Support for Microsoft Windows 2019
- IDERA SQL Safe Backup 8.6 version now supports Microsoft Windows 2019.
8.6 Fixed Issues
Availability GroupAvailability Groups
Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-13888 |
---|
|
Users can now perform Full/Differential backups on the secondary replica and Full/Differential policies on the primary replica.
Backup
- SQL Safe Backup operations
Status |
---|
colour | Green |
---|
title | SQLSAFE-12892 |
The verify bakcup option is now working properly when performing backups to TSM. Status |
---|
colour | Green |
---|
title | SQLSAFE-13438 |
Users can now backup large databases to Amazon S3. Status |
---|
colour | Green |
---|
title | SQLSAFE-13521 |
Scheduled backup jobs are now working properly in a failover cluster environmentavailability groups.
Backup
Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-1393814206 |
---|
|
Users can now perform backups with a remote instance using a non-default port number. Status |
---|
colour | Green |
---|
title | SQLSAFE-13908 |
Improved user experience with T-Log backup operations.
Cluster Environment
...
- backup operations to an Azure location specifying the container name as "Page blob".
Backup / RestoreDesktop Console
Status |
---|
colour | Green |
---|
title | SQLSAFE-1376611856 |
---|
|
The Last Operation Status section is now updating properly the list of backups succeeded and failed.
Grooming
Status |
---|
colour | Green |
---|
title | SQLSAFE-1284213585 |
---|
|
The repository grooming is now set to 365 days. Status |
---|
colour | Green |
---|
title | SQLSAFE-1385413890 |
---|
|
The grooming bitesize option is now set to 1000.
Installation
Status |
---|
colour | Green |
---|
title | SQLSAFE-1398413924 |
---|
|
The recovery model and page verify settings are now set properly when installing SQL Safe Backup.
...
Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-13652 |
---|
|
The license key is now working properly when adding instances in the Web Console.
Management Service
...
Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-956014161 |
---|
|
Restore policies are now working properly when changing the target database name of a restore performed from one server to anotherUsers can now backup and restore large databases to/from Azure and Amazon S3 locations. Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-1340613539 |
---|
|
The Copy Policy feature is now scheduling policies properly. Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-14060 |
---|
|
When performing a backup policy, the location type is now set properly.
Restore
-
Status |
---|
colour | Green |
---|
title | SQLSAFE-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 restorebackup and restore to/from Azure and Amazon S3 cloud base storage using subfolders. Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-1393814193 |
---|
|
Users can now perform restores with a remote instance using a non-default port number.
...
Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-13908 |
---|
|
Improved user experience with T-Log backup operations.
Upgrade
Status |
---|
colour | Green |
---|
title | SQLSAFE-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 |
---|
colour | Green |
---|
title | SQLSAFE-13737 |
---|
|
The SQL Safe Web Console will now prompt users for credentials to access the file system when the initial attempt fails.
Backup
Status |
---|
colour | Green |
---|
title | SQLSAFE-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 |
---|
colour | Green |
---|
title | SQLSAFE-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 Consoleperform AdHoc backup and AdHoc restore operations to Amazon S3 and Azure cloud storage using subfolders. They need to make sure to select the Force Restore (replace) option when performing restore operations. Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-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 |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-955514091 |
---|
|
SQL Safe Backup displays now properly the progress of a backup operations that are being performed without compression. Status |
---|
colour | Green |
---|
title | SQLSAFE-13892 |
---|
|
Backup and restore operations performed in native file format can have timeout values modified through a registry key update. Status |
---|
colour | Green |
---|
title | SQLSAFE-13225 |
---|
|
Percentage values are no longer included in the Result Text of backup and restore operations.
Instant Restore
Status |
---|
colour | Green |
---|
title | SQLSAFE-9722 |
---|
|
Resolved an issue that would prevent an InstantRestore operation from completing successfully.
Management Console Preferences
Status |
---|
colour | Green |
---|
title | SQLSAFE-13350 |
---|
|
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-13891 |
---|
|
Users can now set long passwords for the deployed Backup Agents service account in the Agent Deployment option. Status |
---|
colour | Green |
---|
title | SQLSAFE-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
- Backup and restore operations are now working properly for TSM and Amazon S3 locations.
Cluster Environment
Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-1357713853 |
---|
|
Users Users can now perform Object Level Recovery and Virtual Database operations to a large backup filean agent in a clustered environment.
Operation HistoryFIPS Compliance
Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-13137 |
---|
|
The Database name of every operation performed is kept in the Operation History tab. Status |
---|
colour | Green |
---|
title | SQLSAFE-12154 |
---|
|
The SQL Safe Web Console now displays times in the local time zone.
Policies
Status |
---|
colour | Green |
---|
title | SQLSAFE-13848 |
---|
|
Users can now edit SQL Safe Backup Policies which includes unreachable SQL Server instances and/or SQL Safe Backup Agents.
Repository
Status |
---|
colour | Green |
---|
title | SQLSAFE-11932 |
---|
|
Improvements to the grooming operation.
Restore
Status |
---|
colour | Green |
---|
title | SQLSAFE-13489 |
---|
|
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-13839 |
---|
|
SQL Safe Backup can now successfully restore large backup files that are stored in an Amazon S3 bucket.
SQL Safe Backup Service
Status |
---|
colour | Green |
---|
title | SQLSAFE-13804 |
---|
|
Optimized the SQL Safe Backup Agent to prevent crashes in certain scenarios.
SQL Safe Management Console
Status |
---|
colour | Green |
---|
title | SQLSAFE-13893 |
---|
|
The SQL Safe Management Console is now able to connect to the SQL Safe Management Service without any problems.
SQL Safe Scripts
Status |
---|
colour | Green |
---|
title | SQLSAFE-12867 |
---|
|
Removed the 3200 character limit when performing an operation through SQL Safe Backup.
SQL Safe XSP
Status |
---|
colour | Green |
---|
title | SQLSAFE-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 |
---|
colour | Green |
---|
title | SQLSAFE-13282 |
---|
|
...
Status |
---|
colour | Green |
---|
title | SQLSAFE-13280 |
---|
|
...
Availability Group
...
- Users can now perform backup and restore operations when enabling FIPS compliance. They can save Azure Pub Account details in the Web and Desktop Console.
Policies
...
CLI Commands
Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-1335113546 |
---|
|
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
...
IDERA Dashboard
- Users can now run backup policies to a snapshot database.
Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-13483 |
---|
|
In the SQL Safe Web Console, users are now able to perform backup operations successfully where the target location uses a UNC path. Users can now perform backup policies using subfolders from azure locations.
RestoreObject Level Recovery
Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-13320 |
---|
|
The Object Level Recovery functionality is The Restore wizard is now working properly now when the repository is hosted on SQL Server 2014+ instance.
...
- when restoring backed up databases to Amazon S3 locations in a remote instance.
Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-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 |
---|
colour | Green |
---|
title | SQLSAFE-13560 |
---|
|
The point in time functionality is working properly when mounting a virtual database.
Policies
- Instant Restore operations to large databases are now working properly when it is restored to a new database or to an existing database using the "Force Restore" option.
Upgrades
Status |
---|
colour | Green |
---|
title | SQLSAFE-13366 |
---|
|
Users can now add a database to an existing backup policy. Status |
---|
colour | Green |
---|
title | SQLSAFE-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 |
---|
colour | Green |
---|
title | SQLSAFE-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 |
---|
colour | Green |
---|
title | SQLSAFE-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 |
---|
colour | Green |
---|
title | SQLSAFE-13159 |
---|
|
In the SQL Safe Web Console, users can run now a policy manually. Status |
---|
colour | Green |
---|
title | SQLSAFE-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 |
---|
colour | Green |
---|
title | SQLSAFE-13513 |
---|
|
Users can now supply a UNC path when creating or modifying a policy in the SQL Safe Web Console.
Restore
- After upgrading from SQL Safe Backup 8.5.2 to 8.6, the registration of the Web Console is now successful
Status |
---|
colour | Green |
---|
title | SQLSAFE-13448 |
---|
|
In the SQL Safe Web Console, users can now perform the verify operation using the restore wizard. Status |
---|
colour | Green |
---|
title | SQLSAFE-13372 |
---|
|
In the SQL Safe Web Console, the point in time selection is working properly now in the restore wizard. Status |
---|
| |
---|
colour | Green |
---|
title | SQLSAFE-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 |
---|
colour | Green |
---|
title | SQLSAFE-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 |
---|
colour | Green |
---|
title | SQLSAFE-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 |
---|
colour | Green |
---|
title | SQLSAFE-12858 |
---|
|
Users can now successfully install SQL Safe Backup while using quotes (") in their service account passwords.
Upgrade
- Users can now upgrade the SQL Safe Agent Components from an old SQL Safe Backup product version to 8.6 version properly
Status |
---|
colour | Green |
---|
title | SQLSAFE-13243 |
---|
|
Upgrading will use the existing installation directory rather than using the default path of C:\Program Files\Idera\SQLsafe. Status |
---|
colour | Green |
---|
title | SQLSAFE-12574 |
---|
|
The SQL Safe Agent Components can now be upgraded through the SQL Safe Management Console.
Scroll pdf ignore |
---|
Newtabfooter |
---|
alias | IDERA |
---|
url | http://www.idera.com |
---|
| | Newtabfooter |
---|
alias | Products |
---|
url | https://www.idera.com/productssolutions/sqlserver |
---|
| | Newtabfooter |
---|
alias | Purchase |
---|
url | https://www.idera.com/buynow/onlinestore |
---|
| | Newtabfooter |
---|
alias | Support |
---|
url | https://idera.secure.force.com/ |
---|
| | Newtabfooter |
---|
alias | Community |
---|
url | http://community.idera.com |
---|
| | Newtabfooter |
---|
alias | Resources |
---|
url | http://www.idera.com/resourcecentral |
---|
| | Newtabfooter |
---|
alias | About Us |
---|
url | http://www.idera.com/about/aboutus |
---|
| | Newtabfooter |
---|
alias | Legal |
---|
url | https://www.idera.com/legal/termsofuse |
---|
|
|