Re: Is there a way to find growth in log (ldf) and database(mdf) ?

Query gives the same database size at different intervals , even though
activity has occured on the database.

What I require is to find the size of log file ( every 15 mins )
without actually implementing Log shipping. I need to set up a script
in production server and measure the log size (every 15 mins ) and Log
shipping set up is not allowed  at this point of time .

Thanks

Srinivas

(masri999@gmail.com)  writes:
> Query gives the same database size at different intervals , even though
> activity has occured on the database.
>
> What I require is to find the size of log file ( every 15 mins )
> without actually implementing Log shipping. I need to set up a script
> in production server and measure the log size (every 15 mins ) and Log
> shipping set up is not allowed  at this point of time .

What do you want to know? The size of the log file, or the size of
the transaction log actually in use? The log file only increases in
size when it has to.

For the current log size, DBCC SQLPERF may be an alternative.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp