Prerequisites
With Data Protection for SQL Server, you can back up and restore SQL Server data and protect your SQL Server environment.
- Security requirements for backup and restore operations
Data Protection for SQL Server requires certain settings to process backup and restore operations in a secure environment. - VSS and legacy backup methods
Depending on your SQL Server environment, you can run full backups only, copy-only full backups, full plus log backups, full plus differential backups, or file and group backups. Your backup strategy might also be to back up data to Tivoli® Storage Manager or local shadow volumes. - Enhanced data protection for Microsoft SQL AlwaysOn Availability Groups
You can run VSS (full) and legacy (full, differential, file/set/group, and log) backup operations on a primary replica. You can run copy-only VSS and legacy backup operations, and normal log backups on a secondary replica. You cannot run a differential backup on a secondary replica.