I have a script that dump all of the databases on a Sybase server to
tape.

At the moment I have a new Sybase server on a new RS600 host server
but we have no tapes as yet for it. So I want to bakup all of the
databases to disk .
Is it possible to dump all of the databases to one diskdump device
without one database dump overwriting the previous dump. Like on the
tape when the first dump is with init and the rest are noinit .

Thanks

When you dump to disk, you can dump to a file system/file name . You could
use something like this
declare @devname varchar(254)

select @devname = '/database_backups/db_abc_' + + convert(char(8),
getdate(), 5) + '_' + convert(char(8), getdate(), 8) + '.dat'

dump database db_abc to @devname

The date/time allows for multiple backups to exist.
"Praim Sankar" <psankar (AT) ibc (DOT) ca> wrote

There's a program called psDumpServer in DBPowerSuite that does all this
automatically.

http://www.dbpowersuite.com

"Praim Sankar" <psankar (AT) ibc (DOT) ca> wrote