Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2011
    Posts
    2

    Unanswered: backup few db paralel

    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 ?

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Quote Originally Posted by aswe View Post
    how to freeze it. Can you help ?
    Have a look at "quiesce database"

  3. #3
    Join Date
    Nov 2011
    Posts
    2
    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 ?

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •