Check SQL Server DB Size

Published on Sunday, March 8, 2015

Sometimes we have to check SQL Server database size, especially for SQL Server Express edition since it is free with database file size limitation.

Current SQL Server Express limits the single db file size up to 10GB.

How to check the DB file size? There are multiple ways to get it:

Method 1: The most simple way is using SQL Server Management Studio.

Right click on your database file, select Properties;

image

On General tab, you can see the “Size” of the DB.

image

Method 2:

sp_helpdb command

Mothod 3:

sp_spaceused command