The available backup archives can be viewed (browsed) by right-clicking the target SQL Server instance in the Servers navigation pane and selecting Browse TSM Archives.You can also view this information through the SQLsafe Restore wizard, CLI, or XSP. You can view a list of all available files including those flagged as inactive.

To browse the TSM Server through the Restore wizard, select Tivoli Storage Manager on the Source tab, and then click Browse.

To use the XSP browse command, see the sample XSP scripts available from the Programs menu.

Example CLI code snippets that use the browse command

To browse all active files:

SQLsafeCmd Browse TSM

To browse all active and inactive files:

SQLsafeCmd Browse TSM -TSMIncludeInactive

To browse all active and inactive files in a Highlevel called BACKUP:

SQLsafeCmd Browse TSM -TSMIncludeInactive -TSMHighLevel BACKUP

Tip

TSM is case sensitive. Be careful when specifying the High Level and Low Level file set.

  • No labels