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?
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)
To resume operation run
In your case I would specify that you intend to do a 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