SQL Server backup, restore,
instant recovery, and virtual databases
Database administrators need a robust SQL Server backup and recovery solution that significantly reduces SQL Server backup and recovery time, minimizes storage requirements, and provides enterprise management capabilities to conduct backups across a large number of SQL Servers simultaneously. SQL Safe Backup has been specifically designed to meet these requirements, resulting in increased application and business availability for critical SQL Server infrastructures.
Backup faster and save space via dynamic compression with encryption
Choose from multiple options for advanced and instant recovery
Ensure organizational compliance via policy-based management
Reduce failures due to temporary network problems
Backup & Recovery
- Benefit from advanced backup
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.
- Go beyond object-level recovery
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.
- Automatically adjust compression-versus-space
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.
- Select point-in-time
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.
- Recover from network failure
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.
- Choose from different recovery techniques
Select from conventional and advanced restore capabilities that provide greater flexibility and speed when a restore is required. These techniques provide flexibility and speed, especially for emergency recovery situations.
- Backup from Availability Groups
Configure policies to backup from preferred Availability Group replica. Then restore the database even if the backups originate from different Availability Group members.
- Restore instantly
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
- Protect with advanced encryption
Secure backups by employing encryption via 128-bit and 256-bit advanced encryption standard (AES) with a performance degradation of less than 0.5%
- Support for cloud-based storage
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).
- Mirror backups
Write duplicate backup files to different locations during a single backup operation.
- Integrate with enterprise storage
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.
- Copy logins
Bring recovered databases online faster by allowing SQL Safe Backup to create missing SQL Server logins and resolve any orphaned database users.
Enterprise Management
- Manage with policies
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.
- Store relevant information in central repository
Store all backup and restore information in a central repository to allow for full auditing of backup history across the enterprise.
- View entire enterprise in single console
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.
- Backup and restore with low impact
Run SQL Safe Backup as a separate process outside of the SQL Server process space.
- Benefit from multiple user interfaces
Choose from multiple interfaces including web console, desktop console, command-line interface (CLI), and extended stored procedures (XSP).
- Scale with SQL Server sprawl
Keep up with expanding environments with flexible scaling via SQL Safe Backup.
- Alert and report
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.
Virtual Database
- Retrieve data immediately
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.
- Read and write to virtual databases
SQL Virtual Database provides complete support for read and write operations including inserts, updates, deletes, and database console commands (DBCC).
- Attach full backups
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).
- Use with third-party tools
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.
- Attach multiple backups
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.
Cloud
- Install on Cloud Virtual Machines
Run SQL Safe Backup on cloud virtual machines with Windows – such as Amazon Elastic Compute Cloud (EC2) and Azure Virtual Machines.
- Support SQL Server on Cloud Virtual Machines
Back up to and restore from instances of SQL Server running on cloud virtual machines (such as Amazon EC2 and Azure Virtual Machines).
- Access Mapped Cloud Drives
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.
- Monitor hybrid environments with a single tool
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.
- Directly Access Cloud Drives
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.
IDERA Dashboard services requirements
You need to comply with the following requirements to install the IDERA Dashboard:
Type : Microsoft .NET Framework version
Requirement : 4.0 or later
Suggestions : Make sure to install this software prior to the installation of the IDERA Dashboard. For more information about the .NET Framework, see the MSDN article
.NET Framework Versions and Dependencies.
Type : Microsoft Library
Requirement : msolap.dll
Suggestions : The msolap.dll file needs to be installed where the data collection service runs. The installation will search for the file and if it is not found, it will prompt the user to install the file. This file can be installed by downloading and installing from the latest version of the SQL Server Feature Pack from Microsoft
SQL Server 2016 Feature Pack (choose the ENU\x64\SQL_AS_OLEDB.msi installer).
Type : Operating System
Requirement :
- Windows Server 2008 R2 (86-bit)
- Windows Server 2008 R2 (64-bit)
- Windows Server 2012 R2 (64-bit)
- Windows Server 2016 (64-bit)
- Windows 10 (64-bit)
- Windows 2019 (64-bit)
Suggestions : -
IDERA Dashboard repository requirements
The IDERA Dashboard supports any of the following versions for hosting its repositories:
- SQL Server 2008 R2 - All Editions
- SQL Server 2012 R2 - All Editions
- SQL Server 2014 - All Editions
- SQL Server 2016 - All Editions
- SQL Server 2017
- SQL Server 2019
Browser requirements
The IDERA Dashboard user interface can be accessed via web with the following browsers:
- Internet Explorer IE 10.x+
- Google Chrome
- Mozilla Firefox
- Microsoft Edge
- Safari
Port requirements
The IDERA Dashboard uses the following ports by default:
- Idera Dashboard Core Services port: 9292
- Idera Dashboard Web Application Service port: 9290
- Idera Dashboard Web Application Monitor port: 9094
- Idera Dashboard Web Application SSL port: 9291