Printed 2017/08/22 10:48PM

SQL won't start because there's not enough space to create TEMPDB

By chuckboycejr, 2012/10/25

SQL Server will not start.

You open up the ERRORLOG (...which I would only do with a text editor like gVim that creates a cache of the files it opens and can safely read files that have the possibility of being written to while you are reading it...) and you see:

"Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files"

This typically happens after a long day when you should have left for home a few hours ago, btw...

read more

Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.