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 |
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
 Posted - 2003-01-07 : 19:16:40
|
| Is there an easy way to see how much harddrive space is taken up by a certain database on SQL 2000?--For those with wings, fly to your dreamsIt is all or nothing there is no in-betweenRemember who I was... For me |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-07 : 19:22:57
|
| Use the dir command on the drive and path where the MDF and LDF files are stored.Right-click the database in Enterprise Manager and check the file sizes on their respective tabs.Use sp_spaceused. |
 |
|
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
Posted - 2003-01-07 : 19:25:53
|
| It sounds like you assume I have access to the server, but I can only get to it though enterprise manager and the query manager. Can I still do it?--For those with wings, fly to your dreamsIt is all or nothing there is no in-betweenRemember who I was... For me |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-01-07 : 19:29:54
|
Did you not see these two options ?quote:
Right-click the database in Enterprise Manager and check the file sizes on their respective tabs. Use sp_spaceused.
Damian |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-07 : 19:30:26
|
| He gave you three options. So use number 2 or number 3. Number 2 is for EM and number 3 is for QA. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-07 : 19:31:20
|
| Sorry about the assumption, 99.99% of people using SQL Server do have access to the server.You may even be able to run dir using xp_cmdshell from QA.And you might want to check Books Online for help before posting here.If you did, you might also have found sp_helpdb too.Edited by - robvolk on 01/07/2003 19:36:17 |
|
|
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
Posted - 2003-01-07 : 19:40:05
|
| Sorry for some reason right now my brain is fride and it just not click on option 2 or 3.Thanks for the help guys.--For those with wings, fly to your dreamsIt is all or nothing there is no in-betweenRemember who I was... For me |
|
|
|
|
|
|
Space used