You can use the SQL Safe Restore wizard in the Management Console or the restore command in the CLI or XSP to restore a backup file directly from 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
Restore wizard
Start the Restore Wizard and follow the tabs, setting the appropriate options. On the Sources tab, specify where the backup files are located. You can specify the location using either action:
- On the Repository tab, select the database you originally backed up.
- On the Tivoli Storage Manager tab, select the backup files.
Example CLI code snippets that use the restore command
You can also perform a restore through the CLI. Additional restore options can be set in the SQL Safe Restore wizard, from which you can generate a CLI script that includes the specified wizard settings.
SQLsafeCmd Restore Northwind TSM -InstanceName SQL2000 -TsmHighLevel Backup -TsmLowLevel SQL SafeDEV01_SQL2000_Northwind_Full_200805301028.safe
SQLsafeCmd Restore Northwind Tsm -InstanceName SQL2000 -TsmHighLevel Backup -TsmLowLevel SQL SafeDEV01_SQL2000_Northwind_Log_200805301030.safe
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 restore options, see the usage statements in the CLI Help. To view the CLI Help, type SQLsafeCmd help restore.
XSP
You can restore data files using the XSP. The XSP restore parameters function in the same way as restore options in the CLI. For more information, see the sample XSP scripts available from the Programs menu.