none
SQL Server Transaction Log Files - Out of Memory?

    Question

  • Hi,

    I am running an update query on a very large table (millions of records) and I get a message saying "The transaction log for database 'mydatabase' is full."....Please help me understand the reason for this message. Preferebly why I am seeing it and how I might be able to resolve it.

    Thanks

    Tuesday, November 20, 2012 3:03 PM

Answers

  • Hello,

    All transactions are logged to transaction log file, also your update. Eigher your disk is low in space (is full) or the log file auto-growth is limited in size.


    Olaf Helper

    Blog Xing

    • Marked as answer by ChemEng Tuesday, November 20, 2012 4:14 PM
    Tuesday, November 20, 2012 3:07 PM
    Moderator
  • Each update/delete/insert you do on database, it get recorded in transaction log file. Please read the link 

    The Transaction Log 

    are you referring a production server ..

    Do you regularly take back

    what is the auto growth setings of your db's log file

    vt


    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker


    Tuesday, November 20, 2012 3:08 PM
  • Chemeng,

    You are getting this error message because the transaction log runs out of disk space.

    Per MSDN http://msdn.microsoft.com/en-us/library/ms175495%28v=sql.105%29.aspx

    Following are alternatives for responding to a full transaction log include:

    • Backing up the log.

    • Freeing disk space so that the log can automatically grow.

    • Moving the log file to a disk drive with sufficient space.

    • Increasing the size of a log file.

    • Adding a log file on a different disk.

    • Completing or killing a long-running transaction.


    Thanks
    Manish

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Marked as answer by ChemEng Tuesday, November 20, 2012 4:14 PM
    Tuesday, November 20, 2012 3:10 PM

All replies

  • Hello,

    All transactions are logged to transaction log file, also your update. Eigher your disk is low in space (is full) or the log file auto-growth is limited in size.


    Olaf Helper

    Blog Xing

    • Marked as answer by ChemEng Tuesday, November 20, 2012 4:14 PM
    Tuesday, November 20, 2012 3:07 PM
    Moderator
  • Each update/delete/insert you do on database, it get recorded in transaction log file. Please read the link 

    The Transaction Log 

    are you referring a production server ..

    Do you regularly take back

    what is the auto growth setings of your db's log file

    vt


    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker


    Tuesday, November 20, 2012 3:08 PM
  • Chemeng,

    You are getting this error message because the transaction log runs out of disk space.

    Per MSDN http://msdn.microsoft.com/en-us/library/ms175495%28v=sql.105%29.aspx

    Following are alternatives for responding to a full transaction log include:

    • Backing up the log.

    • Freeing disk space so that the log can automatically grow.

    • Moving the log file to a disk drive with sufficient space.

    • Increasing the size of a log file.

    • Adding a log file on a different disk.

    • Completing or killing a long-running transaction.


    Thanks
    Manish

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Marked as answer by ChemEng Tuesday, November 20, 2012 4:14 PM
    Tuesday, November 20, 2012 3:10 PM