Duplicate of: http://stackoverflow.com/questions/1496136/how-to-find-out-size-of-the-individual-databases-in-the-sql-server-2005
how to find out log size of each of the database in sql server 2005?
+1
A:
In SQL management studio , goto object explorer, right click database, goto "properties" , select "Files" . These you can see one "Initial size" column which will be the size of your DB. you will get both Data and Log file size over here.
Umesh
2009-09-30 05:13:46
Thanks for your help Umesh.I will execute the query and i will update you.
srihari
2009-09-30 10:37:12
+1
A:
You can use this SQL:
EXECUTE sp_msforeachdb 'SELECT *, GETDATE() FROM [?].sys.database_files'
RedFilter
2009-09-30 05:15:00
Hi Orban here i am not getting log file size of database at once.<br>I want like for example A,B are databases in the server then <br>I want total log size of A,Total log size of server B.Thank you very much for your reply.
srihari
2009-09-30 11:13:42
A:
anishmarokey
2009-09-30 05:38:38
A:
If you have rights...
SELECT SIZE/128.0, * FROM sys.master_files MF WHERE MF.type = 1
gbn
2009-09-30 05:52:13