Posted by SQL on 09/29/38 11:27

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

[Back to original message]