You can use the SQL Safe Backup wizard in the Management Console or the backup command in the CLI or XSP to send a backup directly to your TSM Server.

TSM is case sensitive so special care should be taken when specifying the High Level and Low Level settings. Note that SQL Safe accepts up to 260 characters for the TSM file path name.

Backup wizard

Start the Backup Wizard and follow the tabs, setting the appropriate options. On the Locations tab, select Tape (Tivoli Storage Manager), and then specify the following required fields:

  • High Level
  • Low Level
  • Management class (optional)
  • Client Options File (dsm.opt file)
  • Connection Settings

If your backup set is located on a TSM Server other than the server included in the dsm.opt file, you can change the TSM connections settings to override the values set in the client options file. Click Change on this option and specify: Node Name, Node Password, Server Address and Server Port.

You can also configure SQL Safe to mark these files as inactive after a specified age.

Example CLI code snippets that use the backup command

You can also perform a backup through the CLI. Additional backup options can be set in the SQL Safe Backup wizard, from which you can generate a CLI script that includes the specified wizard settings. For example:

SQLsafeCmd Backup Northwind TSM -TsmClientOwnerName tsmclient -TsmClientOwnerPassword password -TsmConfigFile "C:\Program Files\Tivoli\TSM\baclient\dsm.opt" -TsmHighLevel Backup -TsmLowLevel %instance%_%database%_%backuptype%_%timestamp%.safe -TsmManagementClass mclass1 -TsmTcpServerAddress tsmserver -TsmTcpPort 1500

You can use the CLI to change the TSM connections settings for the client options file. The TsmTcpServerAddress and TsmTcpPort options are compatible with any command that supports TSM.

For more information about available backup options, see the usage statements in the CLI Help. To view the CLI Help, type SQLsafeCmd help backup.

XSP

You can perform backups using the XSP. The XSP backup parameters function in the same way as backup options in the CLI. For more information, see the sample XSP scripts available from the Programs menu.



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels