Dear all,

I am working on a project where the storage device can provide mirror of
LUNs of sybase server.
I would like to know how to enable a hot-backup mode such that, after
cloning the LUNs of sybase, the datafiles can still be consistent.
Then I can mount these LUNs for backup purposes.
Thanks all.

Paul

On Thu, 04 Dec 2003 17:44:11 +0800, Paul wrote:

I think the only way to be really *safe* in doing that is to quiesce the
database server before doing the snapshot - the reason being that Sybase
keeps a lot of stuff in memory, and when you snapshot the devices they may
hold an inconsistent state of the data.

Personally I'd stay with using the "normal" backup procedures, or use
replication server.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html

From http://www.experts-exchange.com/Data...20776345.html:
(if you are using Sybase SQL anywher)

1 - I think the best way is to use Sybase-provided utility dbbackup
(included in SQL Anywhere). You can use it to backup running database and to
do an incremental backup (backup only changes in database).

2 - the locking mechanism protects data against concurrent access. When
someone is changing account ballance locking prevents other users to see the
uncommited data. In general you can lock whole database, table, page (set of
rows) or a single row in table.

3 - you don't have to lock the database while backup (if you use the
dbbackup tool) but you have to do so while restoring. Just run the dbsrv.exe
on other communication port - see -x command line paraqmeter.


"Paul" <paultsang (AT) icon-info (DOT) com.hk> ¦b¶l¥ó news:bqn0oq$2ng$1 (AT) news (DOT) hgc.com.hk
¤¤¼¶¼g...