SQL Server Performance

Control File Equivalent..

Discussion in 'SQL Server 2008 General DBA Questions' started by anandchatterjee, Jun 30, 2009.

  1. anandchatterjee New Member

    In Oracle, control files are mainly playing the role for database consistency. Let me draw a scenario.
    When we are committing any transaction, the statement are inserted in the Log file first and a checkpoint takes place and that information is written at the header of the log file as well as a entry is been created in the control file. In this case if the database abnormally shut down and when we try to start the database, then the control files checks the consistency between data and log files and if they are not in sync then the sql statements are executed to bring them in sync and check point number is updated in the data file.
    How this total process is managed in SQL server? What is the equivalent file for Control file? Where the reference information are stored? (i.e. check point number)
    Any comments would be highly appreciated.
    Thanks in advance.
  2. anandchatterjee New Member

    Please provide some clue..

Share This Page