How do I determine the size of my SQL Server database?

Solution 1:

You'll probably want to start with the sp_spaceused command.

For example:

sp_spaceused Returns information about the total size of the database

sp_spaceused 'MyTable' Returns information about the size of MyTable

Read the docs for all the things you can get information about. You can also use the sp_msforeachtable command to run sp_spaceused against all tables at once.

Edit: Be aware the command sometimes returns multiple datasets, each set containing a different chunk of stats.

Solution 2:

The easiest way (no typing!): In SQL 2005/8 from Management Studio, right click the database, select Reports, Standard Reports, Disk Usage (also By Top Tables, Table and Partition).