• @Lance Reger.. The thing is that the tempdb is created every time the SQL Server restarts taking the database template from tempdb. But if the location is not present then the tempdb cannot be re-created. Matter of fact that the tempdb is deleted everytime SQL Server is shutdown. So accidently deleting it means there is no re-covery back directly. Hope I answered the question put forward.

    Tushar