Page History
The Options tab of the SQL Safe Backup Policy wizard Wizard allows you to enter the backup types and options for each operation included in the backup policy.
What information is on this tab?
...
What types of backup can you choose?
On the Options tab, you can choose the types of backups you want for your backup policy. You can specify one, two, or the three types of backup: Full, Differential,or Log, just select . Select the respective backup types and provide their settings.
...
The options for each backup type are hidden unless the backup type is selected for the policy. For more information about backup types, see Understand understand backup types.
What types of compression algorithms are available?
...
For more information about backup compression, see How how to choose compression and encryption.
Tip |
---|
When performing a backup on a SQL Server format, the compression options available are: none and compress backup. |
What types of encryption algorithms are available?
...
If your SQL Server environment requires FIPS compliance , use the AES encryption option. For more information, see Ensure ensure FIPS compliance.
Warning |
---|
When you choose to encrypt an archive, you must designate a password. For security reasons, SQL Safe does not store this password. Ensure you remember the password you select. |
Tip |
---|
When performing a backup on a SQL Server format, the encryption option is not available. |
What additional options are available?
For each type of backup you select, you can also specify the following advanced options:
Options | SQL Safe | SQL Server | Description |
---|---|---|---|
Compression | Available | Available |
|
Encryption | Available | Not available |
|
Pre/Post-Backup Commands | Available | Available |
|
Verify the integrity of the backup when complete | Available | Available |
|
Generate maps | Available | Not available |
|
| |||
Report T-Log operations that are skipped as SUCCESS | Available | Available |
|
Include database logins in the backup file | Available | Not available |
|
Thread Count | Available | Not available |
|
Transaction Log | Available | Available |
|
Checksum: Generate | Available | Available |
|
Checksum: Ignore Errors | Available | Available |
|
Backup: Copy only | Available | Available | Specifies a copy-only backup. This is a copy of the database and cannot be used as part of a restore strategy. It will allow you to take a "snapshot" backup of your database without |
interfering the LSN (log sequence number) order of your backup strategy. | |||
Backup: Read-write filegroups | Available | Available |
|
|
Once you configure options for your backup, click NEXT to select your backup location.
Scroll pdf ignore | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
| ||||||||||||||||||||||||||||||||||||||||||||||||||
Newtabfooter | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal