This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a SQL Script to find the size of Database Files and Log Files in SQL Server.
I am calculating the size using sys.master_files and performing the required division to get size in MB and GB because it is returning 8 KB pages.
The Database Administrator can use this script to get the quick size of Database Files and Log Files of a SQL Server.
SQL Server Management Studio also provides GUI tools for this exercise, but still, I always use a different script to do my DBA task.
1 2 3 4 5 6 7 |
SELECT db_name(database_id) AS DatabaseName ,type_desc AS TypeDesc ,(size * 8) /1024 AS SizeInMB ,(size * 8) /1024/1024 AS SizeInGB FROM sys.master_files ORDER BY name |