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.
|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 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.|