Script to find out data and log file size |

You can use below script to find out data file (*.mdf) and Log file (.ldf) size
exec sp_helpdb [dbName]

or

use [dbName] select str(sum(convert(dec(17,2),size)) / 128,10,2) + 'MB' from dbo.sysfiles

2 thoughts on “Script to find out data and log file size”

thanks.. nice info

could u please explain me why we r dividing by 128 and what is the purpose of 128,10,2

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

2 thoughts on “Script to find out data and log file size”