Hi,

I have one sybase db server and on it 7 databases, application which is connected to this server uses all 7 databases, in one write sth. in other too.
My question is how to backup all 7 db in the same time ? I need to have these dbs consistent. I know how to dump one db, but i could not find how to dump all 7 dbs or how to freeze it.

Can you help ?

Have a look at "quiesce database"

Hi,

Thanks for answer.

I did

quiesce database dbs hold db1, db2, db3 for external dump
and when i type dump database db1 to "/path/to/dump/file" system returns that database is in quiesce mode and it cannot be dumped.

How to resolve this ?

I believe you’ll have to use O/S commands to backup your database files for what you intend to achieve then invoke quiesce database release when done.