Instantly Access Data in Backup Files to Improve Database Continuity

by Sep 5, 2017

Categories

Tags

Administration agent-based monitoring Agentless Monitoring alert responses alert thresholds alerting Alerts Amazon Aurora Amazon EC2 Amazon RDS Amazon RDS / Aurora Amazon RDS for SQL Server Amazon Redshift Amazon S3 Amazon Web Services (AWS) Analytics application monitoring Aqua Data Studio automation availability Azure Azure SQL Database azure sql managed instance Azure VM backup Backup and recovery backup and restore backup compression backup status Backup Strategy backups big data Blocking bug fixes business architecture business data objects business intelligence business process modeling business process models capacity planning change management cloud cloud database cloud database monitoring cloud infrastructure cloud migration cloud providers Cloud Readiness Cloud Services cloud storage cloud virtual machine cloud VM clusters code completion collaboration compliance compliance audit compliance audits compliance manager compliance reporting conference configuration connect to database cpu Cross Platform custom counters Custom Views customer survey customer testimonials Dark Theme dashboards data analysis Data Analytics data architect data architecture data breaches Data Collector data governance data lakes data lineage data management data model data modeler data modeling data models data privacy data protection data security data security measures data sources data visualization data warehouse database database administration database administrator database automation database backup database backups database capacity database changes database community database connection database design database developer database developers database development database diversity Database Engine Tuning Advisor database fragmentation database GUI database IDE database indexes database inventory management database locks database management database migration database monitoring database navigation database optimization database performance Database Permissions database platforms database profiling database queries database recovery database replication database restore database schema database security database support database synchronization database tools database transactions database tuning database-as-a-service databases DB Change Manager DB Optimizer DB PowerStudio DB2 DBA DBaaS DBArtisan dBase DBMS DDL Debugging defragmentation Demo diagnostic manager diagnostics dimensional modeling disaster recovery Download drills embedded database Encryption End-user Experience entity-relationship model ER/Studio ER/Studio Data Architect ER/Studio Enterprise Team Edition events execution plans free tools galera cluster GDPR Getting Started Git GitHub Google Cloud Hadoop Healthcare high availability HIPAA Hive hybrid clouds Hyper-V IDERA IDERA ACE Index Analyzer index optimization infrastructure as a service (IaaS) infrastructure monitoring installation Integrated Development Environment interbase Inventory Manager IT infrastructure Java JD Edwards JSON licensing load test load testing logical data model macOS macros managed cloud database managed cloud databases MariaDB memory memorystorage memoryusage metadata metric baselines metric thresholds Microsoft Azure Microsoft Azure SQL Database Microsoft PowerShell Microsoft SQL Server Microsoft Windows MongoDB monitoring Monitoring Tools Monyog multiple platforms MySQL news newsletter NoSQL Notifications odbc optimization Oracle PeopleSoft performance Performance Dashboards performance metrics performance monitoring performance schema performance tuning personally identifiable information physical data model Platform platform as a service (PaaS) PostgreSQL Precise Precise for Databases Precise for Oracle Precise for SQL Server Precise Management Database (PMDB) product updates Project Migration public clouds Query Analyzer query builder query monitor query optimization query performance Query Store query tool query tuning query-level waits Rapid SQL rdbms real time monitoring Real User Monitoring recovery regulations relational databases Releases Reporting Reports repository Restore reverse engineering Roadmap sample SAP Scalability Security Policy Security Practices server monitoring Server performance server-level waits Service Level Agreement SkySQL slow query SNMP snowflake source control SQL SQL Admin Toolset SQL CM SQL code SQL coding SQL Compliance Manager SQL Defrag Manager sql development SQL Diagnostic Manager SQL Diagnostic Manager for MySQL SQL Diagnostic Manager for SQL Server SQL Diagnostic Manager Pro SQL DM SQL Doctor SQL Enterprise Job Manager SQl IM SQL Inventory Manager SQL Management Suite SQL Monitoring SQL Performance SQL Quality SQL query SQL Query Tuner SQL Safe Backup SQL script SQL Secure SQL Security Suite SQL Server sql server alert SQL Server Migration SQL Server Performance SQL Server Recommendations SQL Server Security SQL statement history SQL tuning SQL Virtual Database sqlmemory sqlserver SQLyog Storage Storage Performance structured data Subversion Support tempdb tempdb data temporal data Tips and Tricks troubleshooting universal data models universal mapping unstructured data Uptime Infrastructure Monitor user experience user permissions Virtual Machine (VM) web services webinar What-if analysis WindowsPowerShell

SQL Server databases are often repositories for large volumes of business-critical data. As the sizes of databases grow, restore operations become time-consuming. Database professionals need to access data in backup files quickly to reduce recovery time and increase application and business availability. Learn how to instantly access your data in backup files via several conventional and advanced recovery capabilities with SQL Safe Backup.

 

The web-based dashboard enables complete, hands-free, automated management of your entire SQL Server backup infrastructure and ensures compliance with the backup and recovery policies of your organization. View alerts from your environment, summary information about your environment, largest databases and longest backups in your environment, and managed instances. Also, add a SQL Server instance, create a policy, backup, and restore directly from the dashboard. 

 

Create policies for backup, restore, and log shipping. See all of the existing policies in your environment. For each policy, see the status, policy type, policy name, databases covered, instances covered, last operation, and last operation with failure. Add a SQL Server instance, create a policy, edit a policy, copy a policy, modify properties, remove and delete, and export. Each policy creates SQL Server jobs across servers, runs the backup and restore operations as specified, monitors the policies to ensure that they remain in compliance, and alerts of any problems.

 

Easily create backup maintenance plans across the enterprise. Automatically create SQL Server jobs across one or more servers for a set of backup operations on a set of databases according to a detailed schedule.

 

See all operations performed by SQL Safe Backup in your environment. For each operation, see the status, details, instance, database, operation, backup type, policy, compressed, uncompressed, ratio, database size, compression, encryption, duration, start time, end time, threads, and actions. Set operation progress, backup again, backup with different options, restore again, restore with different options, add a SQL Server instance, and export.

 

View all instances managed in your environment. For each instance, see the status, instance name, status text, the number of databases, policies and operations, SQL Server version, and actions. Remove and delete an instance, change credentials, perform operations, backup ad hoc, restore ad hoc, create a policy, install a SQL Safe Backup agent, add a SQL Server instance, backup, restore, and export.

 

View a list of all of the databases that belong to your SQL Server instances. For each database, view the status, instance name, database name, database type, last full backup, last diff backup, last log backup, the number of policies, space used, and actions. Backup ad hoc, restore ad hoc, create a policy, add a SQL Server instance, backup, restore, and export.

 

View all servers that host instances in your environment. For each server, see the status, error, warning, ok, computer name, version, management server, maximum load, priority, send status, SQL timeout, virtual desktop infrastructure (VDI) transfer limit, VDI buffers, VDI block size, VDI timeout, and actions. For the agents, change the properties for the management server, send status time interval, maximum load, priority, and debug mode.

 

Easily create a virtual database from a single full backup file: Select any full backup files created by Microsoft SQL Server and SQL Safe Backup, and modify the fields for backup file, host instance, and virtual database name.

 

Easily build a virtual database from multiple backups. Select the backup files (created by Microsoft SQL Server and SQL Safe Backup) to include, and specify how you want the virtual database to display in the console and other SQL Server tools.

 

Manage users, configure SMTP settings for notifications, configure general preferences, and manage licenses.

 

The backup wizard presents a sequence of dialogs to make it easier to perform a backup operation. Select databases for backup, choose the backup type, select the location of your backup files (including in the cloud), configure options for manual backup, configure notifications for manual backup, and generate scripts for backup and restore operations.

 

Backup, restore, instant restore, and object level recovery (OLR) with Amazon Simple Storage Service (S3) and Microsoft Azure Blob Storage. Initiate S3 operations ad-hoc, and select S3 from the backup and restore wizards. Specify Azure Blob Storage as the location for backup and restore files.

 

The restore wizard presents a sequence of dialogs to make it easier to perform a restore operation. Select the target instance for restore, select the databases to restore, select the backup set for the restore (including in the cloud), specify database files, select recovery state and type, configure notifications for manual restore, review details for manual restore, and restore Object Level Recovery. IntelliRestore™ provides graphical point-in-time recovery using a sliding time scale. InstantRestore™ streams data from the backup file on-demand while completing the restore operation in the background.

 

Watch the video for more details:

 www.youtube.com/watch

 

 Try this yourself by downloading the free 14-day trial.