• Such reliance on defaults never ceases to amaze me. First thought is ignorance and competence, finding databases on the OS drive when the server has 15K spinners for the data and log is just bonkers, full recovery without log backup etc.. The funny thing about your example is that the other settings specified are most likely the default values anyway.

    😎