Results 1 to 2 of 2

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

  1. #1
    Guest

    tempdb data has 8Mb and log has 1Mb - but I´m 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 I´m getting message that log is full.

    Once tempdb is shrinked and expanded by the system (we even don´t 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 I´m 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
  •