How To Find Database Size

  1. SELECT DB_NAME(database_id) AS DatabaseName,database_id,  
  2. Name AS Logical_Name, (size*8)/1024 SizeMB  
  3. FROM sys.master_files