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 seconds

Optional

Sets the connection timeout value in seconds for a single SQL instance. Set the value to 0 for infinite timeout of a SQL instance.

BackupInterval_<InstanceName>

10 or greater

Optional

Sets backup interval for an instance.

Last modified: 9/13/2018 2:57:49 PM