Compare LiteSpeed with Native Backups

Product Feature LiteSpeed for SQL Server Native SQL Server

Management

Backup Status

BEST - Databases are color coded to indicate database has been backed up within acceptable timeframes

None

Targets

  • Tape
  • Disk
  • Network Path
  • Tivoli Storage Manager
  • Tape
  • Disk
  • Network Path

Recovery Points

BEST – utilizing as little as 5% of the original database size, multiple recovery points can easily be maintained without large amounts of storage.

POOR – Possible, but requires as much as 20x more disk space than with LiteSpeed.

Ease of use

BEST – Intuitive and dynamic wizards make the backup and restore process easily customizable.

GOOD – Uses a single static dialog box.

Backup Options

  • Attached Files
  • Double-click restores
  • Central Job repository

None

GUI Options

Mirror/striping options are part of the Backup wizard.

Not available in the GUI

Performance

Speed of BU/Rest

BEST – Up to 70% faster

GOOD – Baseline performance

Encryption

BEST – 9 levels

None

Compression

BEST – Up to 95%

None

Optimization

  • Compression level
  • Multi threading
  • Processor affinity
  • Processor utilization
  • Encryption Level

None

Reporting

Centralized Reporting

BEST – Scheduled reporting is available across multiple instances on a single server and multiple servers. LiteSpeed also includes SLA reporting to indicate success/failure rates of backup jobs.

POOR – Only provides one-off per-instance, per-server reporting.