V11 Service Pack 11
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

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

 

 


 



 

Last modified: 2/27/2018 2:37:21 PM