Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2014
    Posts
    42
    Provided Answers: 1

    Lightbulb Answered: DB Refresh in Sybase ASE

    Hi All,

    I want to know how to refresh in sybase ASE using the TRAN dumps which happens for every 30 minutes .

    I have idea on doing a db refresh using the full db dumps only .

    need inputs or document or anything which explain the db refresh step by step using the TRAN Dumps.

    Thanks
    Ram

  2. Best Answer
    Posted by Martijnvs

    "Maybe this helps: Loading a transaction log to a point in time
    Or the syntax page of the load transaction command."


  3. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Maybe this helps: Loading a transaction log to a point in time
    Or the syntax page of the load transaction command.
    I'm not crazy, I'm an aeroplane!

  4. #3
    Join Date
    Feb 2014
    Posts
    42
    Provided Answers: 1
    hey , the link explaination is good , but my confusion is whether we need to load all the trans dumps that got created after the full dump to recover upto the point . So my understanding is that , once the full db dump is completed and then we need to LOAD one by one or all the TRAN dumps at once .

    Could you please clarify on this little more.

  5. #4
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    <oops, double post>
    I'm not crazy, I'm an aeroplane!

  6. #5
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    If you want to restore the database to the most recent point in time, you will have to load all the transactionlog dumps you've made.
    So, load the full db dump, then load the transactionlog-dumps you made after the full dump, one by one. You cannot load mutlple logdumpfiles with one command.
    I'm not crazy, I'm an aeroplane!

  7. #6
    Join Date
    Feb 2014
    Posts
    42
    Provided Answers: 1
    thanks for the update and i have got clear view on db refresh with log dumps

  8. #7
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    You're welcome and good luck. Would you be so kind as to mark my explanation as 'answer'? People can see that this thread has been answered.
    I'm not crazy, I'm an aeroplane!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •