2

I am trying to do a cross-platform (Sun -> Windows) dump and load of a Sybase ASE 15 database. The first time I tried, I got an error saying that the database needed to be in quiesced mode during the backup. What does this mean, and how do I achieve that?

Improve this question

1 Answer 1

Reset to default
2
+100

quiescing a database suspends updates to the database. Essentially making sure nothing happens to the data data while you're dumping or doing some other action.

Note: "hold_tag" can be any string you choose.

From isql (or whatever you use to connect to the db), just run (as sa, or equivalent) 

quiesce database hold_tag hold database, database, etc

To resume operation run

quiesce database hold_tag release

In your case I would specify that you intend to do a dump

quiesce database hold_tag hold database for external dump

Also take a look at the docs here: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.commands/html/commands/commands73.htm

Improve this answer
1

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .