SQL Server Performance

Log file

Discussion in 'General Developer Questions' started by vietcave, Sep 27, 2005.

  1. vietcave New Member

    Hi everyone,

    My database has 2 log files. Do they have the same content?

    If they don't have the same content, how can I switch from one log file to the other as Oracle do by using the statement "ALTER DATABASE SWITCH LOGFILE"?

  2. ghemant Moderator

    AFAIK , theirs no option to switch or tell SQL to use which log file is used , but you can restrict size of LOG


    Hemantgiri S. Goswami
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri Goswami
  3. satya Moderator

    SQL Server woudl automatically choose the required log file and you need not worry about setting the option.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page