see sizes for ALL databases

Question

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

James Moore (Red Gate) SSCrazy Points: 2644 More actions · Answer 1

Have a look at sp_databases (http://msdn2.microsoft.com/en-us/library/ms176070.aspx). You might want to check if the database size includes log files or not.

- James

Kenneth Wilhelmsson SSC-Dedicated Points: 30043 More actions · Answer 2

sp_databases gives you the size of the physical files for each db (data + logfiles)

If you also want to know how much space is actually used inside those files, you can use sp_spaceused.

To get the usage for all db's, you can use (undocumented, but useful)

exec sp_msforeachdb 'use ? exec sp_spaceused'

/Kenneth

Scott Loudon Newbie Points: 2 More actions · Answer 3

PERFECT! Thank you. I hadn't thought about the log files. Those will need a drive of their own.