Backup strategy for Sybase ASE

[lakinhari]

The http://scn.sap.com/community/sybase-ase/blog/2013/05/31/backup-challenges-on-sybase is not available

Urgent:

ASE 15.7

I tried a cross-platform dump and load after running sp_flushstats , checkpoint on the source database,

while loading on the destination server Il get the error 'database not quiesced , run sp_flushstats'

Tried

>quiesce database hold_sct hold sctdb for external dump to "/dbdumps/sctdb/sctdb.gtlmain.20140612.dmp"

go

This did not work dump did not take place : Message in the log indicated quiesce completed successfully

Process 208 successfully executed QUIESCE DATABASE with HOLD option for tag hold_sct. Processes trying to issue IO operation on the quiesced database(s) will be suspended until user executes Quiesce Database command with RELEASE option.

I tried breaking up the command

1. quiesce database hold_sct hold sctdb for external dump

2. dump database sctdb to "/dbdumps/sctdb/sctdb.gtlmain.20140612.dmp"

this message is displayed

QUIESCE DATABASE is in progress on database sctdb. After it completes, this dump will resume automatically.

dump database command is locked by the quiesce command ,

Does this take a long time (DB size is only 3GB)

Quick solution really appreciated

brgds

Lakshmi Reddy

[Former Member]

You do not need to use the QUIESCE DATABASE command for this - this is intended for managing backups externally to ASE.

Try the following sequence :-

stop all database activity

flush stats

dump transaction log

backup

[lakinhari]

Hi

I cant stop all database activity, this is a production environment(24X7 operation)  with  replication.

- lakshmi

[lakinhari]

The only other way was to load the database on the same server in another database and run flushstats and take the dump. This is a long and cumbersome process