Sybase backup & restoration

[former_member251537]

Dear all,

I have taken the backup of our database using

dump database <SID> to "/backups/<SID>.dmp with compression = 4

Kindly advice for the commands to decompress and load the database in to new system

Thanks & Regards,

kathir

[former_member188958 · Accepted solution]

Nothing unusual has to be done, "with compression" style compression is transparent to the LOAD command.  On the new system just issue a

    
     LOAD DATABASE <newsid> FROM "/backups/<SID>.dmp"

When the "with compression" option is used to dump a database, the dump file is created with an uncompressed header (which includes the information you get when you do a LOAD DATABASE WITH HEADERONLY) and a compressed body (containing the data from the database).  The header identifies the dump as being a compressed dump and the compression level used, the LOAD command automatically performs the uncompression for you.

-bret

[former_member188883]

Hi Kathir,

Please refer below SAP notes

• 1585981   SYB: Ensuring Recoverability for Sybase ASE
• 1588316   SYB: Configure automatic database and log backups
• 1611715   SYB: How to restore a Sybase ASE database server (Windows)
• 1618817   SYB: How to restore a Sybase ASE database server (UNIX)

Hope this helps.

Regards,

Deepak Kori