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
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.