Supported Features - Microsoft SQL Server Agent

The following table lists the features that are supported by this Agent.

Feature

Sub-Feature

Support

Comments

Advanced Backup/Archive Options

Data tab - Verify Synthetic Full

Job Retry tab

tick

Media tab - Allow other Schedule to use Media Set

tick

Media tab - Mark Media Full on Success

tick

Media tab - Reserve Resources Before Scan

Media tab - Start New Media

tick

Startup tab

tick

Vault Tracking tab

tick

Comments

tick

Additional options in the Data tab:

Advanced File System Agent Options

Automatic File System Multi-Streaming

On-Demand Data Protection Operation

Restore by Jobs

Restore Data Using a Map File

Comments

Alerts and Monitoring

Global Alerts

tick

Job-Based Alerts

tick

Comments

Backup/Archive Options

Block-Level Backup

tick

Differential Backup

tick

Full Backup

tick

Incremental Backup

Synthetic Full Backup

Comments

tick

Transaction log backup

Do not truncate log

IntelliSnap backup

IntelliSnap backups are only supported on Windows configurations.

Browse

Browse from Copy Precedence

tick

Browse the Latest Data

tick

Browse Using Filters

Exclude Data Before

tick

Find

Full Backup Transparent Browse

Image Browse

No Image Browse

Page Size

Specify Browse Path

Specify Browse Time

tick

Subclient Browse

Use MediaAgent

View All Versions

Comments

Clustering

Netware cluster

Unix Cluster

Windows - Microsoft Cluster (MSCS)

tick

Windows - Non-Microsoft Cluster

tick

Comments

tick

Microsoft Cluster supports Geo-Dispersed Cluster

Non-Microsoft Cluster supports VERITAS Cluster and HP Scalable NAS/PolyServe Cluster

Command Line Interface

Command Line Interface

tick

Comments

tick

Qcreate backupset and Qdelete backupset are not supported.

An out-of-place restore is supported using Save as Script. For more information, refer to Command Line Interface

CommCell Migration

CommCell Migration

tick

Comments

tick

CommCell migration is supported for AlwaysOn Availability Groups.

Content Indexing

Offline Content Indexing

Comments

Data Aging

Basic Retention Rules

tick

Deleting a Job

tick

Extended Retention Rules

tick

Retaining a Job

tick

Unique Data Aging Rules

tick

Comments

tick

For the Microsoft SQL Server Agent, data backed up through file or file group subclients cannot be pruned through extended retention rules.

Data Compression

Client Compression

tick

Hardware Compression

tick

MediaAgent Compression

tick

Comments

Data Encryption

Data Encryption

tick

Third-party Command Line Encryption Support

Comments

Data Multiplexing

Multiplexing

tick

Comments

tick

For Data Multiplexing, the SQL Server does not support the multiplexing of streams "with each other" on to the same media when a data protection operation is performed using the CommCell Console. However, the streams will be multiplexed when the operation is performed using the Command Line Interface.

Deduplication

MediaAgent-Side Deduplication

tick

Source-Side Deduplication

tick

Comments

Delete Backup and Archive Data

Delete Data Using CommCell Console

Delete Data Using Web Console

Comments

File System Backup Quota

File System Backup Quota

Comments

Global Filters

Global Filters

Comments

GRC

GRC

tick

Comments

tick

GRC is supported for AlwaysOn Availability Groups.

Installing 32-bit Components on a Microsoft Windows x64 Platform

Install 32-bit On x64

tick

Comments

Job Restart - Data Protection

Not Restartable

Restarts from the Beginning

Restarts from the Beginning of the Database

Restarts from the Point-of-Failure

tick

Comments

Job Restart - Data Recovery

Not Restartable

tick

Restarts from the Beginning

Restarts from the Beginning of the Database

Restarts from the Point-of-Failure

Comments

List Media

List Media Associated with a Specific Backup Set or Instance

tick

List Media Associated with Index

List Media Associated with Specific Files and/or Folders

List Media Associated with Specific Jobs

Comments

Live Sync

Replication

tick

Failover

Failback

Validation

tick

Multi Instancing

Multi-Instance Installations

Comments

Optimized Scan

Optimized Scan

Comments

Pre/Post Processes

Pre/Post Process with Data Protection and Recovery

tick

Comments

Restore/Recover/Retrieve Destinations

Cross-Application Restores (Different Application version)

tick

Cross-Platform Restores - Different Operating System

Cross-Platform Restores - Same Operating System - Different Version

tick

In-place Restore - Same path/ destination - Same Client

tick

Out-of-place Restore - Different path/ destination

tick

Out-of-place Restore - Same path/ destination - Different Client

tick

Point-in-Time Restore

tick

Restore Data Using a Map File

Restore to Network Drive /NFS-Mounted File System

Table-Level Restore

tick

Comments

tick

See Restores for the SQL Server Agent.

Restore/Recover/Retrieve Options

Automatic Detection of Regular Expressions

Filter Data From Recover Operations

Rename/ Redirect Files on Restore

tick

Restore Data Using Wildcard Expressions

Restore Data with Pre/Post Processes

tick

Restore from Copies

tick

Skip Errors and Continue

Use Exact Index

Use MediaAgent

tick

Comments

Restore/Recover/Retrieve Overwrite Options

Overwrite Files

Overwrite if file in backup is newer

Restore only if target exists

Unconditional Overwrite

tick

Unconditionally overwrite only if target is a DataArchiver stub

Comments

tick

Unconditional Overwrite is supported for the existing messages.

Schedule Policy

Agent Specific Data Protection Schedule Policy

tick

All Agent Types Schedule Policy

tick

Comments

Storage Policies

Incremental Storage Policy

tick

Standard Storage Policies

tick

Comments

tick

Incremental Storage Policy does not support transaction log backup for the SQL Server Agent.

Storage policy can either be created for a full backup, a differential backup (using incremental storage policy), or a transaction log backup.

Subclient Policies

Subclient Policy

Comments

User Administration and Security

Backup Set/Archive Set

Instance

tick

Subclient

Comments

Web Console Support

Web Console Interface

Comments

Loading...