How to know the space used in the data / log file

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

How to know the space used in the data / log file

Author

Topic

chetan_dba
Starting Member

21 Posts

Posted - 2008-04-10 : 05:24:01

Hi,
I have 4 drives in my HDD namely C,D,E,F
On Each Drive, i have my Database Data, Log and Index File.

I wanted to know the Allocated Space / space used in the Database Data / Log or Index File.

What if i am not able to login to Database then how will i determine the used space / free space in the DB File or Log File or Index File.

Thanks in advance.
-- Chetan

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-04-10 : 05:27:13

You can use sp_spaceused to know used and unused space for data and index. But I don't you can see it without logging in.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

chetan_dba
Starting Member

21 Posts

Posted - 2008-04-10 : 07:41:50

Hi,
the above command sp_spaceused will show the space used in the data file
But i wanted to view the space used in Data File , Log File and Index file HDD Pratiation Wise ( C,D,E)

Thanks in advance.
-- Chetan

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-04-10 : 07:49:58

See if this helps: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources