Article Rating

  • 0 Rating(s)
  • 0
  • 0
  • 0
  • 0
  • 0

How do I find out the actual size (not the space allocated) of my database on the SQL server?

How do I find out the actual size (not the space allocated) of my database on the SQL server?

The information in this article applies to:
SQL 2000 Disk space Usage
Stored Procedure


One of the easiest ways to find out the actual size of your SQL database is by using the sp_spaceused command in the Query Analyzer.

To find out the actual size of the database do the following:

  1. Choose Start -> Programs -> Microsoft SQL Server -> and Query Analyzer.

    Note: This will open the Query Analyzer application.

  2. You will be prompted with the Connect to SQL Server dialog box.
  3. Enter your SQL Server Host Name address in the SQL Server field.
  4. Enter your SQL username and password in the Login Name and Password fields respectively.
  5. This will open the New Query window... Enter sp_spaceused and click the Execute Query button.

That's it. You should see the results of the query in the Results frame.

Article ID: 56, Created On: 5/15/2008, Modified: 5/15/2008