http://www.sqlservercentral.com/blogs/chuckboycejr/2012/10/25/sql-wont-start-because-theres-not-enough-space-to-create-tempdb/

Printed 2014/08/01 11:09AM

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-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.