dcsimg
Results 1 to 2 of 2

Thread: Regarding LOG File error in MS-SQL 2K

  1. #1
    Join Date
    Aug 2004
    Posts
    52

    Regarding LOG File error in MS-SQL 2K

    Hi All,
    I was trying to copy a table with data from 1 db to another in MS-SQL 2K.
    However performing the same, I got following error


    "The log file for database 'CoreDBTemp' is full. Back up the transaction log for the database to free up some log space."


    Kindly let me know that what I need to do in this situation? I searched on internet about the same however unable to catch exactly what I need to do?
    What steps do I need to take in this case?

    Thanks in advance.

    Avadhoot

  2. #2
    Join Date
    Feb 2003
    Posts
    1,048
    One of these errors (followed by fix info) has occurred:

    1. The log file of the destination database is full and is set to not expand any further.

    a. Increase the log file's allowable size and set it to expand automatically

    b. Or increase the log file's allowable size and expand it manually

    c. Or backup and truncate the log file to free up some space.


    2. The log file is set to expand automatically, but expanding it by the configured amount will still not be anough free space.

    a. Expand the size of the log file manually.


    3. The disk that the log file is on is out of drive space.

    a. Free up some space on the drive.

    b. Or add a file to the log file on another drive that has space available.

Posting Permissions

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