Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2003
    Posts
    9

    Unanswered: transaction log for the database is full - HELP Urgent

    Hi,

    I have populating our "to be" production db. because of some problems, I have to clear out few tables. Now when I delete the records from one of the table, I get the following error "transaction log for the database is full". I am using Command Window and SQL assist.

    Any Ideas????


    Dave

  2. #2
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150
    Read the log full errors posting right below yours

  3. #3
    Join Date
    Jul 2003
    Posts
    9

    thanks

    Thanks

    Originally posted by mark_maz
    Read the log full errors posting right below yours

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: thanks

    If you had not created your table with NLI, you can use IMPORT from a blank file, /dev/null for example

    Cheers

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74
    You have to create more primary log files and increment the Log file size.
    i had already this problem and with this, i resolved the problem.

    Rui

  6. #6
    Join Date
    Mar 2003
    Posts
    343
    or autoload the table with a blank data file.

Posting Permissions

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