Posted by Erland Sommarskog on 10/01/80 11:27

(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/techinfo/productdoc/2000/books.asp

• Next in forum: Re: searching a list of tables, derived from another table
• Prev in forum: Re: search on concatenated fields in sql server
• Thread view: Re: Is there a way to find growth in log (ldf) and database(mdf) ?

[Reply to this message]