A quick video showing that the mdf and ldf files are actually ** NOT ** dropped during server restart. Thanks to Mike for bringing up this topic. https://www.youtube.com/watch?v=N4eB-uY5MYI … Continue reading Proof that tempdb mdf and ldf files are **NOT** dropped at the OS level when SQL Server is restarted