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