on 06-12-2014 7:27 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.