SQL Server Performance Forum – Threads Archive
way to view free file space in SQL 2005 dbHi all, As much as I resent saying farewell to Taskpad, I can’t find alternative tool to quickly see the FREE SPACE left in the database files.
select * from sysfiles does not provide it. Any clues?
To display data and log space information for a database
In Object Explorer, connect to an instance of SQL Server 2005 and then expand that instance. Expand Databases and then click the database to view it. From the toolbar, click View and then click Summary. In the Summary pane, click Report.
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Yes, this is on SQL 2005 Server. But I only using SQL 2005 Management Studio to connect to SQL 2000 server, so Reports are grayed out.
sql_machine, The best way to do this is: SELECT name ,size/128.0 – CAST(FILEPROPERTY(name, ‘SpaceUsed’) AS int)/128.0 AS AvailableSpaceInMB
http://www.sqlservercentral.com/col…00tosql2005wherehavealltheoldfeaturesgone.asp I wrote an article sometime ago on the subject, but I think I forgot to include this option in there. Hope this helps.
[<img src=’/community/emoticons/emotion-2.gif’ alt=’‘ />]Thanks, this is great!<br /><br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by BikeBoy</i><br /><br />sql_machine,<br /><br />The best way to do this is:<br /><br />SELECT name ,size/128.0 – CAST(FILEPROPERTY(name, ‘SpaceUsed’) AS int)/128.0 AS AvailableSpaceInMB<br />FROM SYSFILES<br /><br /><br /<a target="_blank" href=http://www.sqlservercentral.com/columnists/bBaliner/sql2000tosql2005wherehavealltheoldfeaturesgone.asp>http://www.sqlservercentral.com/columnists/bBaliner/sql2000tosql2005wherehavealltheoldfeaturesgone.asp</a><br /><br />I wrote an article sometime ago on the subject, but I think I forgot to include this option in there. Hope this helps.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">