Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008
    Posts
    1

    Unanswered: Adding Log files

    Hi,

    I am using MS2k5, just want to know if we can add a Log file to tempdb in a production server, if needed?

    Like shrinking tempdb requires no activity in it and also in some cases server needs to be in single user mode and restarted too.

    Does increasing the log files also come in similar cases.

    Thanks in Advance,
    Ak
    Last edited by akhalique; 06-19-08 at 01:04.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Additional log files for any database, including tempdb, will only come in handy if you have the situations with long-running transactions that modify a lot of data, and may potentially "take out" the existing log file. With addition of log files (if the first one is not allowed to grow) you're preventing the entire transaction to be rolled back, but rather "spill" the needed data modifications to continue being recorded in additional log files, until the transaction ends.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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