Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    40

    Unanswered: storage - transaction log...

    In MSQL Server 2000 how can I expand or use multiple transaction logs because the hard disk i am using windows dont have more than 4 GB free and the query i want to run overcomes this space.
    I have another one HDD with 20-30 GB free space and i want to use this disk so to use a second transaction log or move this log to this disk.
    Can this be happen and how ????

    Thank you in advance

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Transaction log is written to sequentially, and in the case with multiple log files they are being used in a round-robin fashion, meaning that the first one needs to be filled up until the next one starts being used. This means that you can create a new log file on the other hard drive and go about executing your query.
    "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
  •