Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- sys.dm_server_services - How to check if SQL Server service is running or not?
- Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
- Can we restore a database to an older version in SQL Server?
- How do I save all SQL Agent Jobs
- How to view SQL Server mount point space without access to server
- DBCC SHRINKFILE: page could not be moved because it is a work table page.
- SQL Agent Last Modified explanation
- Sql certificate chain was issued by an authority that is not trusted
- sqlserver-dba.com switching from feedburner to follow.it
- Taking transaction log backup and full back at the same time
SQL Server - Find the Database File Size and Log File Size
17 September,2012 by Tom Collins
A quick way to to find the Database File Size and Log File Size, by querying the sys.master_files.size column.
The sys.master_files.size column returns the file size in 8 KB pages. Therefore some division is required to calculate in MB and GB.
If the sys.master_files = ROWS it’s a data file . If the sys.master_files = LOGS it’s a log file .
select db_name(database_id) as dbname, type_desc,(size * 8) /1024 as size_MB, (size * 8) /1024/1024 as size_GB from sys.master_files order by name
Related Posts
Attach database without log file and rename database
SQL Server – files and filegroups. Improving database performance
Author: Tom Collins (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |