V11 SP8
Loading...

Additional Settings for Backing Up Transaction Logs Without a CommServe Connection

To run transaction log backups without a CommServe connection, you must create and then enable the following additional settings on the client computer.

For steps on creating additional settings from the CommCell Console, see Adding or Modifying Additional Settings from the CommCell Console.

Additional Settings Value Mandatory/Optional Description
SqlLogBackupStageFolder Path to a stage folder, such as C:\StageFolder Mandatory

(Only for standalone environment)

Sets a path to the stage folder in a standalone environment.

Verify that the stage folder has enough space to contain the backed up data. The data is automatically deleted after it is backed up to the MediaAgent. If needed, you can set SQL compression from the SQL Management Studio.

<clustername>StageFolder Path to a shared stage folder, such as O:\StageFolder Mandatory

(Only for clustered environment)

Sets a path to the stage folder in a clustered environment. Verify that the following conditions are true:
  • The shared path is accessible by all cluster computers.
  • The stage folder has enough space to contain the backed up data.

The data is automatically deleted after it is backed up to the MediaAgent. If needed, you can set SQL compression from the SQL Management Studio.

bTLBackupToFS 1 Mandatory Enables the backup of transaction logs to the stage folder. By default, the backup runs every ten minutes.
backupFromFSForLog 1 Mandatory Enables the backup of transaction logs from the stage folder to the MediaAgent.
nSQLLogBackupInterval Number of minutes Optional Sets the frequency for transaction log backups to the stage folder. By default, the backup runs every ten minutes.
nDBperCollectFile 30 or greater Optional Sets the number of databases per collect file. A collect file contains those databases associated with the subclients configured in the CommCell Console.

Backup performance is slower when you run simultaneous transaction log backups on several databases. To speed performance, group 30 or more databases under each collect file and then run parallel transaction log backups on the databases under each collect file.

nAutoDiscoverSQLInstanceTimeout Number of minutes Optional Reduces the time interval for running a SQL instance discovery, if the databases are created or renamed frequently. By default, the SQL instance discovery runs every 24 hours.
DisableTlog_<InstanceName> 0, 1 Optional Enables and disables staging of transaction log backups without a CommServe connection for an instance.
SQLTimeout_<InstanceName> Number of minutes Optional Sets the connection timeout value for single SQL instance. Set the value as 0 for infinite timeout of SQL instance.
BackupInterval_<InstanceName> 10 or greater Optional Sets backup interval for an instance.