title: Hard drive space vs Database space
body: <p>Our database server has 2 disks; disk C has 40GB free space according to file explorer and disk D is full. The database is comprised of partitions stored in both drives. When I run the following SQL command to see the available space left on the database </p>
  
  <pre><code>select name
  , filename
  , convert(decimal(12,2),round(a.size/128.000,2)) as FileSizeMB
  , convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)) as SpaceUsedMB
  , convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) as FreeSpaceMB
  from dbo.sysfiles a
  </code></pre>
  
  <p>I see that space left on the mdf file is at 3Gb and decreasing every day. When there is no space left will the database simply crush? Or will it auto-grow and gain some space that is available on C drive? How can I set it to automatically request more hard drive space?</p>