What's New in LiteSpeed for SQL Server 8.5? (4329950)

SQL Server 2016 support

Support of Sql Server 2016 has been added.

Object Level Recovery performance

   Object Level Recovery has been enhanced by adding multi-threading support which results in a significant (marked) improvement of Object Level Recovery speed.
   Note that on the Recover Table Wizard | Advanced Options | Direct Mode is selected by default and
   performs faster than the Bulk Insert alternative.

Transaction Log Reader scalability

  The Log Reader has been enhanced by adding multi-threading support which results in a significant (marked) improvement of Transaction Log Reader scalability.

Restore from a different SQL Server instance

In the Restore Wizard you can now select the SQL Server instance and database to restore from.

Automated Restore

Restore Verify Only option has been added. This allows you to verify backups in Automated Restore without real database restoring.
New option Verify the latest full or differential backup has been added. Use this to check only the latest backup without needing to check the full restore chain of backups.

Restore to Different Instance reporting
A new report Restore by Source has been added to the LiteSpeed activity reports.
The report shows restore activities performed on different SQL Server instances for backups created on the selected SQL Server instance in the tree.
NOTE: Central repository is required.

Backup

The default backup name and description can now include the AlwaysOn Availability Group name by using the variable %AG%. This allows you to group databases into folders based on the AlwaysOn
Availability Group name. It is ignored for databases that are not in an AlwaysOn Availability Group.

Backup Templates

The location for Transaction Log backups can now be set independent of the Fast Compression / Full backups location. The path can be modified for each instance at deployment time.
You can now use the Backup Template to exclude individual databases within the selected categories of all databases, system databases, user databases and databases matching a wildcard or regular expression. Further to this, individual databases can be excluded at deployment. The path to the Transaction Log backup is visible from the LiteSpeed Console.

Multi-Database Backup

There is a new Exclude Databases step to the Backup Wizard. If you selected to include all databases,
system databases or user databases then you can use the Exclude Databases step to select those databases you do not want backed up.

Backup folder creation now has automatic retry logic

 LiteSpeed now makes 3 attempts for folder creation at 0.5 second intervals.

Database Properties

The Database Properties dialog from the Backup Manager now indicates whether FileStream is enabled. A new Stretch Database property is also included for SQL Server 2016 Stretch Databases.

Support for IAM Roles on Amazon EC2

LiteSpeed now supports IAM Roles authentication on Amazon EC2 virtual machines connecting to S3 storage.

Regions added to Amazon S3 Cloud

London, Canada, US East (Ohio) and Mumbai India have been added to the Amazon S3 Cloud region selection list.

Azure Cold Storage

LiteSpeed has been tested with Azure Cold Storage. It is fully compatible.

Enhancements

The following is a list of enhancements implemented in LiteSpeed for SQL Server 8.5.

Table 1: Backup and restore enhancements

Table 3: Log Shipping enhancements

 Table 4: Common enhancements