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
We also cover some quirky behavior by tempdb where it still detects the changes in model database and persists them to tempdb after the restart. More on that in the next video.
Please Consider Subscribing
