DATABASE BACKUP IN SYBASE

[#1]

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 Member]

Hello Sudheer,

With the above command everything will be backed up. Until unless during this backup duration no transactions are happening.

Usually transactional backups are useful when backup is old one(may be one old) and current transactions are backed up using transactional backup. In this case you will need both complete backup as well as transactional backup.

With above explained scenario you will be able to restore complete system.

Regards

Anand