DATABASE BACKUP IN SYBASE

[former_member230979]

Dear all,

I have one doubt. we are taking backup of our sybase database using isql editor with command

isql -Usapsa -SSID -Ppassword -X

use KEP

go

dumpdatabase SID to "/db/....dmp"

go

with this command is everything will backed up  or else can i take backup separately for transaction logs tempdb etc..i am new to sybase please

guide me regarding on this. Is it possible to completely restore the database with the above taken database backup using the above commands.

Best regards,

venkat.

[former_member89972 · Accepted solution]

Full database dump includes the transactions up to the point the database backup runs.

Dump transaction releases transaction log space used by committed transactions.

"truncating transaction log"  takes place only via  "dump transaction" command.

If dump transaction is not run the available transaction logs space keeps reducing till it gets full and then no further transaction can take place for that database.

Bottom line

dump database  is full database backup, but does not release transaction log space

dump transaction is needed to restore transactions after the last full backup up.

HTH

Avinash