Versions Compared

Old Version 11

changes.mady.by.user Alejandra Rivera

Saved on

compared with

New Version Current

changes.mady.by.user Alejandra Rivera

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The The Options tab of  tab of the SQL Safe Backup Policy wizard Wizard allows you to enter the backup types and options for each operation included the backup policy.

For each backup operation you include in the backup policy, you can select compression, encryption, verification options, and set additional advanced options.

What types of backup can you choose?

You can specify one, two, or the three types of backup: Full, Differential Differential, Log Log.

Select which backup types you want for your policy and provide the respective settings. Take into account that the options for each backup type are hidden until the backup type is selected. For more information about backup types, view Understand understand backup types.

What types of compression algorithms are available?

SQL Safe provides the following compression algorithms: 

  • None.
  • IntelliCompress, optimize for size (iSize).
  • IntelliCompress, optimize for speed (iSpeed).
  • Levels 1, 2, 3, 4.
Info

Backup operations using Level 1 complete fastest but achieve the least amount of compression. Level 4 achieves maximum compression but the backup operation may take longer.

For more information about backup compression, see How how to choose compression and encryption.

Tip
When performing a backup under the SQL Server format, the compression options available changes to an option to use compression.

What types of encryption algorithms are available?

SQL Safe provides the following encryption algorithms:

  • None.
  • AES (128-bit).
  • AES (256-bit).

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 or take note of the password you select.

Tip

When performing a backup under the SQL Server format, the encryption options are not available.

What additional options are available?

SQL Safe Backup provides additional options that can be applied to SQL Safe Backup Policies.

The available options, which are listed below, are dependent following list describes options that are available depending on the backup format format (SQL Safe or SQL Server) chosen on the General screentab.

Options

SQL SafeSQL Server

Description

Use compression
Not available
AvailableAvailable
  • You designate the compression rate necessary to match your storage needs.
EncryptionAvailableNot available
  • Select the level of encryption you need to ensure data security within your environment.
Verify the integrity of the backup when completeAvailableAvailable
  • Verifies the integrity of the backup set data files created by this backup.
  • Verifying the backup helps identify potential issues that could occur when restoring these data files.
Generate mapsAvailableNot available
  • Generates maps containing metadata for each database included in your backup file. This option is selected by default.
  • Depending on the number of transactions completed since your last backup, generating maps may impact the performance of the backup operation.
  • Generating maps is optional, but it should exist in the backup file for InstantRestore to accept and restore that file.
  • SQL virtual database can attach SQL Safe backup files without the metadata, but the data files improve SQL VDB performance during tcreation of the virtual database.
  • For more information,
see Recover objects using SQL virtual database
Report T-Log operations that are skipped as SUCCESSAvailableAvailable
  • Allows SQL Safe to report SKIPPED T-Log operations as SUCCESS.
  • Avoids backup policies from reporting a warning status when T-Log operations are skipped for databases that are in simple recovery.
Include database logins in backup fileAvailableNot available
  • Copies SQL login information for the selected databases, including credentials and privileges, when the backup files are written.
  • To help ensure the security of your SQL Server database, SQL Safe encrypts the login information. This option is available for full backups only.

Thread Count

AvailableNot available
  • Allows you to specify how many threads you want SQL Safe to use to distribute the backup operation across multiple processors on the target SQL Server computer. Use this setting to optimize backup performance.
  • When the resultant backup file is restored, SQL Safe uses the same thread setting to ensure consistent performance.
  • Select Auto to have SQL Safe determine the optimal thread count for your environment.
Transaction LogAvailableAvailable
  • Removes all completed transactions and inactive entries from the transaction log after SQL Safe finishes the backup.

Checksum: Generate

AvailableAvailable
  • Generates a checksum for the backup file.
  • It must be enabled to allow the Checksum: Ignore Errors availability.

Checksum: Ignore Errors

AvailableAvailable
  • If the Checksum: Generate option is enabled, then either format is available.
  • If checksum errors are encountered, this option determines that SQL Safe should continue to backup process.

Backup: Copy only

AvailableAvailable
  • Specifies a copy-only backup. This is a copy of the database and cannot be used as part of a restore strategy. 
  • Allows to take a "snapshot" backup of your database without interfering the LSN (log sequence number) order of your backup strategy.

Backup: Read-write filegroups

AvailableAvailable
  • Specifies a partial backup, which includes the primary filegroup and any read-write secondary filegroups. 
  • If this option is selected, the Generate metadata option (Generate maps for InstantRestore and SQL virtual database) will be disabled.
  • Backups created with the read-write filegroups option cannot be used by SQL virtual database to create virtual databases.

After defining your setting in this tabOnce you configure options for your backup, click NextNEXT to Select select your backup locationslocation. 



SQL Safe  is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
Scroll pdf ignore
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResourcesLegal

...

Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 | 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 | 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 | 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse