1 |
originally posted 2015-02-16 |
Pilfered and tweaked from internet postings.
1 2 3 |
select [SizeBytes] = convert(bigint,sum([size]))*8*1024 from sys.master_files with(nowait) where database_id = db_id('DATABASE_NAME_HERE') |