Can Sybase display size, db filename, etc from a compressed file without restoring the compressed db?
Posted on 2007-07-30
I am relative unfamilar with how Sybase uses compressed files.
can Sybase read the contents of a compressed file to show me the size of the database contained in the compressed files as well as table and column information? I would like to see such information without actually loading the database contained in the compressed files.
Here is a sample of the Sybase load statement
load database merrin
stripe on 'compress::6::/net/locki/export/dumps/support/clientDbs/mftp/BPI/merrin_02.zmp'
stripe on 'compress::6::/net/locki/export/dumps/support/clientDbs/mftp/BPI/merrin_03.zmp'
stripe on 'compress::6::/net/locki/export/dumps/support/clientDbs/mftp/BPI/merrin_04.zmp'
stripe on 'compress::6::/net/locki/export/dumps/support/clientDbs/mftp/BPI/merrin_05.zmp'
The system uses SQL Advantage/Sybase 12.5.3.
Basically, I would like to how the Sybase equivalent of MS-SQL Server's RESTORE FILELISTONLY FROM DISK.