Sybase backup on disk problem

[former_member459694]

Hello,

I am trying to backup sybase database to disk with multiple dumps within one file,

I use command dump database PRD to "/sybase/backup/BACKUP_PRD.DUMP" with noinit

but it seems the noinit didn't work, each time the new backup will overwrite the old one, that means always we will only have one dump.

is it possible that we dump multiple backups into one single file? I am working on linux OS.

Thanks a lot.

Best regards,

Fresh

[former_member200876 · Accepted solution]

i can sent you presentation describe the procedure steps

[former_member459694 · Accepted solution]

This message was moderated.

[former_member200876 · Accepted solution]

I sent the file to you

[former_member459694 · Accepted solution]

Hello Ezzat,

Thank you for the file, but my pain point is: how to avoid renaming dump file each time.

I would like to dump database to a SINGLE FILE (a big file contains maybe 4-5 backups)

Best regards,

Fresh

[former_member200876 · Accepted solution]

i think there is no way to avoid rename dump file , actually we do back by this way

[former_member459694 · Accepted solution]

Hello all,

As discussed with SAP, this proves to be impossible, to backup multiple database dump into just one file on file system, instead, we could do the backup using configuration file, that will automatically generate filename with date time in it to distinguish the names. no need to rename everyday.

sp_config_dump @config_name='testdb_cfg',@stripe_dir='/sybase/dbbackup/'go

dump database PRD using config= testdb_cfg

go

anyway, thanks a lot for all your help.

Fresh

[vijay_kumar49]

http://scn.sap.com/thread/3283981

[former_member200876]

first log in to your database

then choose  "File" menu

select " open interactive SQL "

in " Master " DB used the following syntax :

dump database xyz to "/sybase/backup/BACKUP_PRD.dmp"

VIP Notes :

xyz= your database name

BACKUP_PRD.dmp = the dump file name

Best Regards

M. Ezzat

[former_member459694]

Dear Ezzat,

my sybase works on linux operating system instead of windows, and the backup device is DISK, not tape

Fresh

[Sriram2009]

Hi Fresh

Could you refer the Linka

SyBooks Online

http://scn.sap.com/thread/3358549

Regards

Sriram

[former_member200876]

my suggest solution for Sybase under Linux , and the dump file will saved in the Disk

[former_member459694]

Hello all friends,

Could take a close look at what's my problem? actually I can backup sybase well, the problem is that I can not dump database into one DUMP file, for example, the backup on Tuesday night will overwrite the backup on Monday night, all the time there is only one copy of backup.

I use File system (disk) as backup device, not tape, so that "with noinit" doesn't work?

Thanks!

Fresh

[former_member200876]

change the dump file name every time such as :
BACKUP_PRD1.DUMP

BACKUP_PRD2.DUMP

BACKUP_PRD3.DUMP