CODEWITHSUNDEEP
sqlsql-serversql-server-2005
Srihari
Srihari

Reputation: 2519

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

Duplicate of: 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?

Upvotes: 0

Views: 241

Answers (5)

gbn
gbn

Reputation: 432271

If you have rights...

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

Upvotes: 0

anishMarokey
anishMarokey

Reputation: 11397

How to determine SQL Server database transaction log usage

try this :

DBCC SQLPERF(logspace)

Upvotes: 0

RRUZ
RRUZ

Reputation: 136391

try this

dbcc sqlperf(logspace)

Bye.

Upvotes: 1

D'Arcy Rittich
D'Arcy Rittich

Reputation: 171411

You can use this SQL:

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

Upvotes: 1

Umesh
Umesh

Reputation: 1242

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.

Upvotes: 1

Related Questions