About schedule properties (SQL Server Intelligent Policy)
This topic describes how to configure certain schedule properties for SQL Server Intelligent Policies. Other schedule properties vary according to your specific backup strategy and system configuration. Additional information about other schedule properties is available in the NetBackup Administrator's Guide, Volume I.
Table: Description of schedule properties describes how the schedule properties affect a SQL Server Intelligent Policy.
Table: Description of schedule properties
Property | Description |
|---|---|
| Specifies the type of backup that this schedule can control. The selection list shows only the backup types that apply to the policy you want to configure. See Schedule backup types for SQL Server Intelligent Policies. |
| You can schedule a backup in one of the following ways:
|
Specifies a retention period to keep backup copies before they are deleted. The retention period for a schedule controls how long NetBackup keeps records of when scheduled backups occurred. Set the time period to retain at least two full backups of your database. In this way, if one full backup is lost, you have another full backup to restore. The type of schedule you select affects the retention period as follows:
| |
Multiplexing is useful if you have many simultaneous backups using the same tape drive. However, it can interfere with SQL Server recovery due to how SQL Server requests streams during restore. In most cases, Veritas does not recommend multiplexing multiple SQL Server streams from the same backup to a single tape. |