Protecting data

You can back up and restore your Microsoft SQL Server data by using Microsoft Management Console (MMC) or the command-line interface.

About this task

If required, you can manage your installations remotely.

Tip: For information about protecting Microsoft SQL Server data in VMware environments, see the chapter that explains in-guest application protection in the Data Protection for VMware User's guide.

Prerequisites
With Data Protection for SQL Server, you can back up and restore SQL Server data and protect your SQL Server environment.
Starting Microsoft Management Console
After you complete the configuration process, start Microsoft Management Console (MMC) to protect your SQL Server data.
Starting the Data Protection for SQL Server command-line interface
You can start the Data Protection for SQL Server command-line interface by using a Windows command prompt with administrative privileges. Alternatively, you can start the command-line interface from Microsoft Management Console (MMC).
Managing Data Protection for SQL Server installations remotely
From a single Data Protection for SQL Server installation you can manage all of the Data Protection for SQL Server installations in your enterprise.
Determining managed storage capacity
You can track the capacity of managed storage assets. This information can be useful when you are calculating storage requirements for license renewal.
Managing backup, restore, and automation tasks in the Task Manager
The Task Manager provides you with a centralized view of Microsoft Management Console (MMC), from which you can view, stop, remove, or manage backup, restore, and automation tasks.
Backing up SQL Server data
By using Microsoft Volume Shadow Copy Service (VSS), you can back up SQL Server data and mount the backup if required. You can also create legacy backups of SQL Server databases, groups, and files.
Restoring SQL Server databases and files
You can restore legacy backups of SQL Server databases, file groups, and files by using Microsoft Management Console (MMC).
Protecting SQL Server data in a Windows Server Core environment
Server Core is a minimal and low-maintenance server environment where you can run the minimum services that are necessary to maintain Windows Server 2008 and later versions. You can install and operate Data Protection for SQL Server in this minimal server environment.
Viewing, printing, and saving reports
You can access reports on recent activity and historical managed capacity. You can determine which licenses and software are installed.