V11 Service Pack 10
Loading...

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

Media tab - Allow other Schedule to use Media Set

Media tab - Mark Media Full on Success

Media tab - Reserve Resources Before Scan

Media tab - Start New Media

Startup tab

Vault Tracking tab

Comments 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

Job-Based Alerts

Comments

Backup/Archive Options

Block-Level Backup

Differential Backup

Full Backup

Incremental Backup

Synthetic Full Backup

Comments Transaction log backup

Do not truncate log

IntelliSnap backup

IntelliSnap backups are only supported on Windows configurations.

Browse

Browse from Copy Precedence

Browse the Latest Data

Browse Using Filters

Exclude Data Before

Find

Full Backup Transparent Browse

Image Browse

No Image Browse

Page Size

Specify Browse Path

Specify Browse Time

Subclient Browse

Use MediaAgent

View All Versions

Comments

Clustering

Netware cluster

Unix Cluster

Windows - Microsoft Cluster (MSCS)

Windows - Non-Microsoft Cluster

Comments

Microsoft Cluster supports Geo-Dispersed Cluster

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

Clustering is only supported on Windows configurations.

Command Line Interface

Command Line Interface

Comments

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

Comments CommCell migration is supported for AlwaysOn Availability Groups.

Content Indexing

Offline Content Indexing

Comments

Data Aging

Basic Retention Rules

Deleting a Job

Extended Retention Rules

Retaining a Job

Unique Data Aging Rules

Comments 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

Hardware Compression

MediaAgent Compression

Comments

Data Encryption

Data Encryption

Third-party Command Line Encryption Support

Comments

Data Multiplexing

Multiplexing

Comments 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

Source-Side Deduplication

Comments

Delete Backup/Archived Data

Delete Data by Browsing

Delete Stubs

End-User Delete

Comments

File System Backup Quota

File System Backup Quota

Comments

Global Filters

Global Filters

Comments

GRC

GRC

Comments GRC is supported for AlwaysOn Availability Groups.

Installing 32-bit Components on a Microsoft Windows x64 Platform

Install 32-bit On x64

Comments

Job Restart - Data Protection

Not Restartable

Restarts from the Beginning

Restarts from the Beginning of the Database

Restarts from the Point-of-Failure

Comments

Job Restart - Data Recovery

Not Restartable

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

List Media Associated with Index

List Media Associated with Specific Files and/or Folders

List Media Associated with Specific Jobs

Comments

Multi Instancing

Multi-Instance Installations

Comments

Optimized Scan

Optimized Scan

Comments

Pre/Post Processes

Pre/Post Process with Data Protection and Recovery

Comments

Restore/Recover/Retrieve Destinations

Cross-Application Restores (Different Application version)

Cross-Platform Restores - Different Operating System

Cross-Platform Restores - Same Operating System - Different Version

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

Out-of-place Restore - Different path/ destination

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

Point-in-Time Restore

Restore Data Using a Map File

Restore to Network Drive /NFS-Mounted File System

Table-Level Restore

Comments 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

Restore Data Using Wildcard Expressions

Restore Data with Pre/Post Processes

Restore from Copies

Skip Errors and Continue

Use Exact Index

Use MediaAgent

Comments

Restore/Recover/Retrieve Overwrite Options

Overwrite Files

Overwrite if file on media is newer

Restore only if target exists

Unconditional Overwrite

Unconditionally overwrite only if target is a DataArchiver stub

Comments Unconditional Overwrite is supported for the existing messages.

Schedule Policy

Agent Specific Data Protection Schedule Policy

All Agent Types Schedule Policy

Comments

Storage Policies

Incremental Storage Policy

Standard Storage Policies

Comments 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

Subclient

Comments

Web Console Support

Web Console Interface

Comments