Backup & Recovery
Advanced compression, disk writing, and multi-threading technologies significantly increase the backup speed. Reducing backup time increases the available window to perform other critical SQL Server tasks.
The IntelliCompress2™ technology continually samples the system resource usage and automatically adjusts the compression level to ensure the smallest backup files in the fastest time given the state of the environment.
Automatically pause the backup and restore processes when a temporary network problem occurs. Automatically resume after the network is back online to prevent backup and restore failures.
Configure policies to backup from preferred Availability Group replica. Then restore the database even if the backups originate from different Availability Group members.
Recover objects faster than with object-level recovery (OLR), recover from all backup file types (such as full, differential, and transaction log files), and recover all objects.
Restore from any point in time. Simply select a point-in-time graphically using a sliding time scale to automatically assemble all of the backup components necessary to restore the database to the specified point in time.
Select from conventional and advanced restore capabilities that provide greater ﬂexibility and speed when a restore is required. These techniques provide flexibility and speed, especially for emergency recovery situations.
Bring databases online immediately to eliminate application downtime. Stream data from the backup file on-demand to support applications and user requests while completing the restore operation in the background.
Security & Storage
Secure backups by employing encryption via 128-bit and 256-bit advanced encryption standard (AES) with a performance degradation of less than 0.5%.
Write duplicate backup files to different locations during a single backup operation.
Bring recovered databases online faster by allowing SQL Safe Backup to create missing SQL Server logins and resolve any orphaned database users.
Select Amazon Web Services (AWS) Simple Storage Service (S3) and Microsoft Azure Blob Storage as the location for backup, restore, instant restore, and object level recovery (OLR).
Backup to and restore from EMC Data Domain servers, and permanently store backup files to IBM Tivoli Storage Manager (TSM) to adhere to corporate storage standards.
Define and automate backup, restore, and log shipping schedules across multiple databases, servers, and server groups with policy-based management. Eliminate scripts and overhead of native backup and recovery.
View real-time and historical monitoring of backups and restores and job management capabilities. The dashboard view displays backup and restore issues, created backup policies and more from one consolidated view.
Choose from multiple interfaces including web console, desktop console, command-line interface (CLI), and extended stored procedures (XSP).
Store all backup and restore information in a central repository to allow for full auditing of backup history across the enterprise.
Run SQL Safe Backup as a separate process outside of the SQL Server process space.
Keep up with expanding environments with flexible scaling via SQL Safe Backup.
Alert on the result of any operation including failures, warnings, misses, and successes. Access a comprehensive catalog of reports for best practices that are delivered using SQL Server Reporting Services.
Gain instant access to data in a backup file without wasting time or storage necessary to restore the database. Create a virtual database from a full native or SQL Safe Backup file with three simple steps in just a few minutes.
Attach a full backup of any size and select a new name for the virtual database. It then shows up just like any other database in SQL Server Management Studio (SSMS).
Choose a series of backups to run queries, reports, and other analysis against. Find out which rows were added, modified, or deleted since the last backup.
SQL Virtual Database provides complete support for read and write operations including inserts, updates, deletes, and database console commands (DBCC).
Virtual databases look, act, and behave like actual live databases. Use any native SQL Server or third-party tools to query and extract all of the needed data.
Run SQL Safe Backup on cloud virtual machines with Windows – such as Amazon Elastic Compute Cloud (EC2) and Azure Virtual Machines.
SQL Safe Backup can access cloud storage that is mapped as network drives or removable drives on Windows. For example, backup to and restore from Amazon S3 and Azure Blob Storage.
Back up to and restore directly to the cloud. Automatically and manually backup to a single file or multiple striped files on the local computer and a network share, Amazon S3, and Azure Blob Storage.
Back up to and restore from instances of SQL Server running on cloud virtual machines (such as Amazon EC2 and Azure Virtual Machines).
Avoid learning new tools by using the same backup tool for SQL Server on-premises on physical and virtual machines, in the cloud on virtual machines, and the cloud as managed databases.