Results 1 to 2 of 2

Thread: tempdb data has 8Mb and log has 1Mb - but Im getting message that log is full - how to fix

  1. #1
    Guest

    tempdb data has 8Mb and log has 1Mb - but Im getting message that log is full - how to fix

    Hello,

    I have the following situation.

    tempdb data file has 8Mb and log file has 1Mb - but Im getting message that log is full.

    Once tempdb is shrinked and expanded by the system (we even dont see it at database folder!!), what can be done, (except reinstall from scrach and restore DBs) to make tempdb not vulnerable to very frequent expanding/shrinking (I guess this can be one of the root of the problem) ?

    TIA

    Massa/mig

  2. #2
    Jim Craddock Guest

    tempdb data has 8Mb and log has 1Mb - but Im getting message that log is full - how to fix (reply)

    I think you can assign a minimum size. Just pick a goodly size minimum and let it resize if it needs to to get bigger than that.


Posting Permissions

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