Finding total size of the database in sql server


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:)
Ebook Download
View all
Learn
View all