SQL Server parameters

The following table describes SQL Server parameters that are used in Defining a Control-M for Backup Job for TSM.

(Windows only) You must use a UNC or local path for all fields that require a file path (mapped drives cannot be used).

Parameter

Description

DB Name (SQL)

Defines the names of the SQL server databases to back up, restore, inactivate, or query

Mode (SQL)

Determines one of the following backup types:

  • File: Backs up a specific file
  • Full: Backs up the full database
  • Diff Full: Backs up the changes since the latest full backup
  • Log: Backs up the transaction log for an active database since the latest successful log backup
  • Group: Backs up the contents of the file group you specify
  • Set: Backs up the contents of the file groups and files you specify with the /files and /groups parameters

File Name

Defines the name of the file for a File backup

Group Name (SQL)

Defines the file group for a Group backup

Groups

Defines the groups for a Set backup

Files

Defines the files for a Set backup

Config File

Defines the name of the Data Protection for SQL or Mail configuration file

Log File

Defines the name of the backup log file

Option Files

Overrides the default TSM option file (dsm.opt)

Wait for storage to be mounted

Determines whether to wait for the media mount or stop the current operation

Truncate

Determines whether to truncates the log file

Output Management

Determines one of the following log types to display:

  • Display none
  • Display only errors and warnings
  • Display full log

Parent Topic

Tivoli Storage Manager Job parameters