We can retrieve database sizes using below query: 1. with fs as ( select database_id, type, size * 8.0 / 1024 size from sys.master_files ) select Read More MSSQL list all databases size