CommVault: Solutions: Microsoft SQL Server

CommVault Solutions — Microsoft SQL Server

Overview

Microsoft SQL Server technology is the basis for many applications which are critical to managing and running a business. These include various applications developed by third-party vendors for customer relationship management, supply chain management, business performance analysis and reporting, as well as Exchange and SharePoint products and technologies. If your business relies on SQL Server, then you need a data management solution you can rely on for your business.

SQL Server Data Management Requirements At-A-Glance

CommVault® software covers the spectrum of what you need to manage SQL Server data, starting with database and transaction log management for the SQL Server system itself, and extending to broad Windows systems management to ensure that the entire SQL Server environment is managed and easy to recover.

SQL Server Components

CommVault® Capabilities Performed from the Unified Console

SQL Server System

Windows File System
SQL Server database
SQL Server transaction logs

Back up
Replicate — Remote
Snapshot — Local
Recover
Transaction Log Replay for Point-In-Time Recovery
Log Shipping
Disaster Recovery
Report

SQL Server Disaster Recovery Management

Backup copies
Replication copies
Snapshot copies
Windows System State disaster recovery copies

Set Storage Policies
Encrypt
Compress
Browse
Search
Recover
AUX Copy
Track Removable Media
Report

CommVault® Singular Information Management® Solution for SQL Server

CommVault provides a comprehensive suite of software for managing SQL Server databases, along with comprehensive transaction log management. You can use any of these capabilities on a stand-alone basis. You can also use them in combination to obtain compounded benefits of running a Singular Information Management® environment—managed from a Unified Console.

SQL Server Challenge

CommVault® Offering

Data Protection of SQL Server

Database backup and restore, including transaction log management

CommVault Galaxy® Backup & Recovery software with iDataAgents (iDAs) for SQL Server provides online protection of the database, along with transaction log protection and replay for easy point-in-time recovery. Easy management of log shipping to other SQL Server systems is also provided.

CommVault Galaxy software also protects and restores the entire SQL Server and Windows platform environment, and provides object-level Active Directory protection. This coordinated protection and recovery makes it easy to manage SQL Server.

Windows File System backup and restore

Windows platform protection, including System State recovery

Active Directory Domain Controller protection

Replication of SQL Server

Move data from remote SQL Servers to central locations for data protection

Continuous Data Replicator provides host-based, asynchronous Windows replication of any Windows data, including SQL Server. Unique SQL Server-consistent recovery points ensure that the replicated database is coherent, and that it usable for backup and restore at the central site.

Disaster recovery of SQL Server databases that is up-to-the-moment of a site disaster

Dramatically improve RPO/RTO service levels for protecting and recovering the SQL Server database

Quick Recovery manages array-based snapshots on a SAN to create SQL Server recovery volumes, and to manage point-in-time recoveries.

Use a snapshot as the basis for creating a CommVault Galaxy backup copy of SQL Server

Recovery Director automates the steps for using a snapshot recovery volume created with QuickRecovery, for the purpose of making an SQL Server backup copy.

Resource Management of SQL Server

Monitor and manage the amount of primary disk space being consumed by SQL Server

Storage Manager collects data from production SQL Server systems and provides a separate reporting console so that you can analyze the use of primary disk by SQL Server.

Monitor and manage the amount of disk space being consumed by archives, backup copies and replication copies

CommNet Service Manager builds on the extensive data collection and reporting already built into other CommVault products, to give you a complete view of the use of secondary storage, including backup, archive and replication data copies. This can be helpful for capacity planning and global policy management.