on 11-26-2015 11:29 AM
Hi All,
I am little confused when to use which command for backup.
Can I use Quiesec database instead of Dump database all the time?
Or Should I use Quiesec database only at particular point in time.
What is the exact difference? Once I did a DB restore from Production to Quality where Quality was at 15.7 SP121 and Production was 15.7 SP50.
To do this I have used "DUMP DATABASE SID TO E:\BACKUPS\SIDBAK.DMP". I have restored to file to quality with LOAD DATABASE command.
Everything went fine but the version of quality remained same in SP121. I do have some idea as I have only loaded SAP data to Quality.
But My concern is to restore entire database what exactly has to be used? To make exact copy as production.
Please help me to understand this.
Best Regards,
Amarnath
Hi Amarnath,
Here is an SCN linked from april Backup strategy for Sybase ASE | SCN the question was answered in detailed by Bret Halford's Profile | SCN this explains what the quiesce does.
Hope this will help you.
Kind Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amarnath,
You can use "quiesce database" To Suspend and later resume updates to a specified database. This will be helpful to put the database in the same state.
Dump of the database , You can take with/without putting the database in suspended state.
But if you want that database should be in the same consistent state during the time you want to take backup , Then you can use "quisce database" and take the backup . Hope this is clear.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.