Did you ever think about an integration between Sybase ASE and “Tivoli Storage Manager” (TSM) provided by IBM ?
As far as I knew, IBM did not offer such kind of tool to interface Sybase ASE and TSM and, as far as I knew, no such kind of interface exist from any other vendor. Sure, you can still buy “SQL Backtrack” that provides direct backup to TSM through their OBSI… But from my point of view SQL Backtrack becomes obsolete regarding the new backup capabilities of Sybase ASE. So it is an expensive solution to buy SQL Backtrack just to link directly ASE with TSM to perform backups… What a pity, it could sometimes make the DBA’s life easier to backup databases directly to TSM…
But the good news is such kind of product finally exists and is named “Data Protector” !!
Data Protector will allow you to backup your Sybase ASE databases using TSM. Data Protector is a command line driven backup and restoration tool.
Unfortunately I can’t test it in the environment I’m currently working in (TSM administrators do not allow me to test it). But I think it deserves a look. Repostor is the company providing this product. You can visit their company website here: http://www.repostor.com/joomla.
Features available in this product are:
- Full backup of all databases
- Full backup of selected database(s)
- Full restore of all databases
- Full restore of selected database(s)
- Restore of database to a new machine
- Restore of database to a new database / instance
- Query to TSM. What backup versions do I have?
- Pick older version of backup for restoration
They even provide a video to install an use the product, you can see it below:
