Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011
    Posts
    10

    Unanswered: What happens to data in the data cache during a power failure

    Hi..

    As we understand that the data cache contains the pages that are recently accessed by ASE along with system tables, active log pages and parts of indexes. What happens of the system goes down and what would happen to the data in the data cache?

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Datacaches get cleared when a server stops/starts, data that has not yet been written to disk is lost.
    If there are finished transactions that are in the transaction log but are not yet written to disk they are rolled forward when the server starts. Unfinished transactions and any changes they may have made are rolled back.
    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
  •