Protecting Microsoft SQL Server data in Hyper-V environments

Installing and configuring software for application protection of Microsoft SQL Server
To protect a guest virtual machine (VM) that hosts Microsoft SQL Server data, you must complete installation and configuration steps on the Hyper-V host and the guest VM. Use the step-by-step instructions to help you get your environment up and running for in-guest application protection.

Managing backup operations
After you configure the environment for to protect of Microsoft SQL Server data, you can schedule backups. You can set up schedules for a virtual machine (VM) backup operation and a Microsoft SQL Server log backup operation.

Restoring data
After you back up a virtual machine with the application protection feature enabled, you can recover a database in case the original is lost or damaged.

Sample script for validating full virtual machine backups
Before you back up Microsoft SQL Server logs, verify that you have a valid full virtual machine (VM) backup. One procedure for checking for the existence of a full VM backup is to schedule the usage of a script.

IBM Spectrum Protect file space information
You might never need to know the file names or locations for your virtual machine (VM) files. However, if the underlying file structure interests you, Data Protection for Microsoft Hyper-V backups are stored under the node name of the Hyper-V target node (for example, KINGSTON5_HV_TGT) on the IBM Spectrum Protect server.