TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Finding total size of the database in sql server
Lajapathy Arun
Jul 04, 2012
3.3
k
0
0
facebook
twitter
linkedIn
Reddit
WhatsApp
Email
Bookmark
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:)
Finding total size of the database in sql server
Next Recommended Reading
How to Retrieve the File Size used by a SQL Server Database on Hard Disk