Microsoft SQL Server forum - Re: Is there a way to find growth in log (ldf) and database(mdf) ?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

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

SQL

2005-09-22, 11:24 am

Unless the file expands the size won't change
When you have autogrow of 10 percent and you fill up only 8 percent the
file size won't change until it hits that threshold

http://sqlservercode.blogspot.com/

masri999@gmail.com wrote:
> 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

Sponsored Links