Results 1 to 3 of 3

Thread: Log File

  1. #1
    Join Date
    Oct 2004
    Posts
    16

    Unanswered: Log File

    If your database is set to unrestricted log file growth can anyone tell me why the log file becomes full? I get this error. "Back up the transaction log for the database to free up some log space. [SQLSTATE 42000] (Error 9002)" After about three or four days now on a consistent bases. I don't believe it is because I am running out of disk space. ?????????

    Tom

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    What is your current filesystem ... FAT or NTFS ???
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    It has to be the case, you can't get this error for any other reason other than when running out of disk...It is NTFS, isn't it?
    "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
  •