Finding total size of the database in sql server
we are going to see the total size of the database
sp_spaceused Returns information about the total size of the database
Syntax:
Exec sp_spaceused
OUTPUT:
database_name database_size unallocated space
-----------------------
myDB 3.00 MB 0.74 MB
reserved data index_size unused
------------------ ------------------ ------------------ ------------------
1288 KB 584 KB 632 KB 72 KB
Thanks:)