Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jay1Jay
Yak Posting Veteran
50 Posts |
 Posted - 2004-08-04 : 16:47:22
|
| I have been given a task to figure out size of each SQL database within my company.... My question is can I just look at the Data directory and capture the database.mdf file size, will that be the correct size or do I have to go in to each server Enterprise Manager and look at the properties of each databases....Reason is we are consolidating SQL server into one and trying to figure out disk space which can accomdate all these databases...... So any suggestions will be appreciated...Thanks,Jay |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-08-04 : 16:57:43
|
| Look at sp_spaceusedBrett8-) |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-08-05 : 03:11:42
|
| Well, the database is (currently) only as big as the total of its .MDFs and .LDFs, but some of the space in those files may be empty. Of course, were you to move the databases, you may still need that empty space. If you're just doing a "will it fit" exercise at a very basic level, you wont go far wrong just adding up the sizes in the directories. Otherwise view --> taskpad can be useful (in EM) or sp_spaceused and dbcc sqlperf (logspace).-------Moo. :) |
|
|
|
|
|
|
Database Sizes