Log File

  • Hi. I configured the initial size of log file on a 7GB database to 3GB. Transactions logs are scheduled hourly (0800 to 1800).

    I set the log file to unrestricted growth, growing in increments of 500MB.

    I checked today. The database reports Log File growth and shrinkage. The log file initial size is now 100MB and Restricted Growth is now selected with a value of 2,097,152?

    I am told no changes have been made.

    Any thoughts as to why the initial log file size would shrink and the Restricted Growth value set?

    Regards,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

  • Update:

    Found this link in another post:

    http://www.exactsoftware.com/Docs/DocView.aspx?DocumentID={2b24915c-66b5-4cec-a70b-e3cb414b8821}

    Unclear why the initial size would reset to 100MB from 3GB however?

    I will double check a job has not been scheduled to shrink.

    Regards,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

  • Check database Autoshrink option. Is it on?

  • I will take a look this evening and post back.

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

  • That did the trick.

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply