How to Obtain SQL Server Database Size

There are multiple ways you can use to obtain the SQL server database size. In this article, we are going to share the steps using the Microsoft SQL Server Management Studio.

Launch the Microsoft SQL Server Management Studio, right-click on the database and choose New Query. You can use one of the following queries,

exec sp_databases;

or

exec sp_helpdb;

or

select name, size, size * 8/1024 'Size (MB)', max_size
FROM sys.master_files where db_name(database_id) = 'YOUR-DB-NAME'

Alternatively, right-click on the database and choose Properties.

Under the General page, you will see the size of the database.