Post reply

tempdb backup transaction log

  • May 20, 2004 at 10:28 am

    #85582

    Get this message in log. The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space..

    How do you clear tempdb or backup transaction log

     

     

  • May 20, 2004 at 11:04 am

    #507162

    The reason that you are getting the problem is not so much that the log is full, more likely you are running some query that is growing tempdb until the disk is full (tempdb will grow and shrink itself).

    You should look at moving tempdb to another drive where there is more space, allowing it to grow sufficiently to prevent this.


    Shamless self promotion - read my blog http://sirsql.net

  • May 21, 2004 at 8:27 am

    #507293

    Or if you do have enough space, you don't have TEMPDB set to automatically grow fast/large enough.

    -SQLBill

  • May 21, 2004 at 3:01 pm

    #507361

    Backup Log <database name> with Truncate_Only

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply