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 2008 Forums
 Other SQL Server 2008 Topics
 Space Check

Author  Topic 

arvind_ramugade
Starting Member

30 Posts

Posted - 2011-12-16 : 06:04:40
How do we check the available/free space on a server side ?



ramugade

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2011-12-16 : 06:06:58
You mean to say available/free space of a DB?

If yes, use "sp_spaceused"

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008
Go to Top of Page

arvind_ramugade
Starting Member

30 Posts

Posted - 2011-12-16 : 06:10:20
Hi,
sp_spaceused will give me free/available space statistics in database not on server side.


ramugade
Go to Top of Page

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2011-12-16 : 06:14:01
"server side" what exactly you looking for Free space of a Disk/Drive?

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008
Go to Top of Page

arvind_ramugade
Starting Member

30 Posts

Posted - 2011-12-16 : 07:34:54
Yes..


ramugade
Go to Top of Page
   

- Advertisement -