Easy Way to Check Space Usage in Your Microsoft SQL Database
Written by Naveed Ashraf Tuesday, 19 February 2013
This step show you the space usage by your SQL database and by its log file. This will show space size in MB.
1. Open Microsoft SQL Server Manager Studio to connect with SQL Database
2. Click on your database to select your database
3. Create new query
4. Now use below T-SQL Script into this newly opened Query windows
5. Execute this query by clicking Execute Button or press F5 Key to execute it.
SELECT DB_NAME() AS DATABASENAME
, NAME AS FILENAME
, SIZE/128.0 AS CURRENTSIZEONDISK_MB
, CAST(FILEPROPERTY(NAME, ‘SPACEUSED’) AS INT)/128.0 AS SPACEUSED_MB
There is no variable used in this query so no need to change anything.
Looking for quality web hosting? Look no further than Arvixe Web Hosting!