Home > Archive > MS SQL Server > July 2005 > RE: Transaction Log space allocated changes automatically always lower









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: Transaction Log space allocated changes automatically always lower
Alejandro Mesa

2005-07-15, 11:23 am

Is there any scheduled job that is shrinking the transaction log?


AMB

"gb via webservertalk.com" wrote:

>
> Hi
>
> I have a database that is in Full recovery mode. I have allocated my
> transaction log space of 250mb. Automatically throughout the day sql 2000
> lowers the amount to 54mb.
>
> I really want the space allocation to stay at 250mb.
>
> How do I stop this happening.
>
> Ta
> GB
>
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com