Quiesce DB

Rob Verschoor

2006-02-02 14:20:17 UTC

40-50 Gb in < 5 minutes seems ambitious if the devices copies have to be
physically moved as well.

Anyway, quiesce database itself doesn't do much; it just facilitates that
consistent copies of database devices can be made. The speed with which you
can do this is not really related to ASE, but depends on the disk system
used. Quiesce database can be used with EMC's Timefinder for example: once
the DB is quiesced, you can split the mirror on EMC level and use the device
copies to start a different ASE server. EMC can split the mirror very fast
(don't ask me for numbers). There's a white paper about Quiesce database and
EMC on sybase.com that spells it out:
http://www.sybase.com/detail?id=1020459

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"

mailto:***@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

Post by unknown
We have ASE 12.5.3 servers running on Solaris 8. Have a reqt
to quickly (under 5 min) dump/load a 40 - 50GB db into
another ASE 12.5.3 server. Have read a bit about
Quiesce/mount/unmount. Is there clear information on how to
use these and facilitate such backup/restore operations.
Also need is info from first-handers about how long this
process takes to copy a 50GB db into another.
Your responses are highly appreciated. Sreekanth.