Restore Databases in Tivoli Storage Manager to Different Target Databases

With Adaptive Server 15.7 SP100, you can load Tivoli Storage Manager-based backups into a different database on a different server when using the dump history file.

Earlier versions of Adaptive Server supported the use of dump database with TSM:

dump database source_dbname to "syb_tsm::object_name"

where:

source_dbname – is the name of the source database.
syb_tsm – is the fully qualified TSM name that specifies the name of the server and database from which you made the backup, using:
```
-S source_server -D source_dbname
```
object_name – is a name of the target database.

In Adaptive Server 15.7 SP100, the fully qualified TSM name is stored in the dump history file. Using the load database... as syntax allows you to restore a differently named database on a different server.

Performing this dump database command changes the information in the dump history file to correctly identify the fully qualified path of your object in TSM.

After you perform this command, the sp_dump_history system procedure displays the fully qualified TSM object name.

After you back up your database stored in TSM, you can restore it using:

load database source_dbname AS
      target_dbname with listonly=create_sql

The general form of the output generated is:

 load database target_dbname
            from syb_tsm::[[-S source_sever][-D source_dbname]
                  ::]object_name
            [stripe on syb_tsm::[[-S source_sever]
                  [-D source_dbname]::]object_name
           [[stripe on syb_tsm::[[-S source_sever]
                  [-D source_dbname]::]object_name 
          load tran target_dbname
            from syb_tsm::[[-S source_sever]
                  [-D source_dbname]::]object_name
            [stripe on syb_tsm::[[-S source_sever]
                  [-D source_dbname]::]object_name
           [[stripe on syb_tsm::[[-S source_sever]
                  [-D source_dbname]::]object_name