Skip to Content

Re: Backup strategy for Sybase ASE

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2014 at 08:58 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.