how to find out log size of each of the database in sql server 2005?

Question

Duplicate of: How to find out size of the individual databases in the sql server 2005?

can any one provide me a solution. I will be clear this time if A,B are the databases in my Server. I want log size of database A,Log size of database B. — Srihari
– Srihari, Commented Sep 30, 2009 at 11:19

D'Arcy Rittich · Accepted Answer · 2009-09-30 05:15:00Z

1

You can use this SQL:

EXECUTE sp_msforeachdb 'SELECT *, GETDATE() FROM [?].sys.database_files'

answered Sep 30, 2009 at 5:15

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Srihari Over a year ago

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.

D'Arcy Rittich Over a year ago

Your question sepcified "each database", that is what the above does.

Umesh · Accepted Answer · 2009-09-30 05:13:46Z

1

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.

answered Sep 30, 2009 at 5:13

Umesh

1,2421 gold badge13 silver badges26 bronze badges

1 Comment

Srihari Over a year ago

Thanks for your help Umesh.I will execute the query and i will update you.

RRUZ · Accepted Answer · 2009-09-30 05:19:40Z

1

try this

dbcc sqlperf(logspace)

Bye.

answered Sep 30, 2009 at 5:19

RRUZ

137k20 gold badges365 silver badges489 bronze badges

Comments

anishMarokey · Accepted Answer · 2009-09-30 05:38:38Z

0

How to determine SQL Server database transaction log usage

try this :

DBCC SQLPERF(logspace)

answered Sep 30, 2009 at 5:38

anishMarokey

11.4k2 gold badges36 silver badges47 bronze badges

Comments

gbn · Accepted Answer · 2009-09-30 05:52:13Z

0

If you have rights...

SELECT SIZE/128.0, * FROM sys.master_files MF WHERE MF.type = 1

answered Sep 30, 2009 at 5:52

gbn

434k84 gold badges602 silver badges690 bronze badges

Collectives™ on Stack Overflow

how to find out log size of each of the database in sql server 2005?

5 Answers 5

2 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related