Posted by SQL on 10/01/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

• Next in forum: Re: search on concatenated fields in sql server
• Prev in forum: Re: Linked server
• Thread view: Re: Is there a way to find growth in log (ldf) and database(mdf) ?

[Reply to this message]