This step show you the space usage by your SQL database and by its log file. This will show space size in MB.

Steps:-

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.

T-SQL Script:-
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
FROM SYS.DATABASE_FILES

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!