General (SQL)
Use this property page to specify general preferences for the SQL Server workload. This property page applies if the product is configured to back up data to stand-alone storage or Tivoli® Storage Manager.
- SQL Server
- Specify the unique name that identifies the SQL Server instance.
- From Server
- Specify the SQL Server backups that you want to use for the restore. By default, this field displays the same name for the SQL Server.
- Wait for tape mounts for backup or restore
- Select this box when you want Data Protection for Microsoft SQL Server to wait for tape media to be mounted for backup and restore operations. This setting is applicable when the Tivoli Storage Manager server is configured to store the backup data on tape media. With backup data on removable media, during backup and restore operations, a wait period occurs during storage volume mounts. If a wait occurs, this setting specifies whether Data Protection for Microsoft SQL Server waits for the media mount or stop the current operation. By default, this option is not selected.
- Use VSS backups as the default backup method
- Select this box to set VSS backups as the default backup method. Ensure that the Local DSMAGENT Node name field is specified in the VSS Backup property page. Backups can be restored only by using VSS.
- Compress backup by using SQL Server compression
- Select this box to enable SQL Server compression during legacy backup operations. This check box is available only if you are running Microsoft SQL Server 2008 or later versions.
- Compute SQL Server checksum for legacy backup
- When selected, this option is written to the Data Protection for SQL Server preferences file (tdpsql.cfg), and can be applied to all legacy backups. If you clear the check box, you ensure that the integrity check does not apply to any legacy database backup.
- Estimate % change for differential backup
- Specify the value for the estimated change to database pages for
differential backups. This estimate is used by Data Protection for Microsoft SQL Server to
determine whether enough storage space is available for the backup.
The default value is 20. This value becomes the default value for
all differential backups.
This field applies only to Data Protection for Microsoft SQL Server legacy backups.