Data space available - SQL Server Forums

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 2000 Forums

SQL Server Administration (2000)

Data space available

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-13 : 08:48:48

Vivek writes "SQL 2000 & WIN 2000 with service pack 6.0??? I have 2 file groups which consistes of 400 MB & 200 MB for data & index respectively. When I use the "dbcc perflog" it provides me the log % used. How do I get the similar information for the data files with no index. Also when I check the properties on the database it gives me the overall statistics (Log & data)of the space available.

Thanks

Vivek Balakrishnan"

Jay99

468 Posts

Posted - 2002-03-13 : 09:00:20

http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=13789

echo off

Jay

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources