Introduction

Many applications, including SQL Server by default, will use the C drive for everything. Having mdf/ldf files stored on the C drive (usually where Windows Server OS is installed) is a bad idea and a time bomb. Bad idea as you don’t want to use the same drive that was used for Windows (file pagging etc…), and need to use separate drives to achieve better peformance. It’s a time bomb as you will quickly run out of space, and SQL Server will stop working.

Problem

Check if any database files are stored on the C drive (excluding master, msdb, model)

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_check_server_database_file_drive.sql