Post reply

SQL Server 2000 Changing size of log files.

  • September 12, 2008 at 1:53 pm

    #71088

    I changed the size of log files (1-7 out of 18) from 127m to 1g, logs 8 to 18 are 1g already.

    After about 10-15 minutes the sizes of logs 1-7 were restored back to 127m. Does anybody

    run into similar issues before? Appreciate any info.

    Thanks,

    Ben

  • September 12, 2008 at 2:47 pm

    #871340

    check to see if autoshrink option ticked on the database. (In EM, right click database, properties, options).If it is and this is a production database, un-tick it

    ---------------------------------------------------------------------

  • September 13, 2008 at 3:29 am

    #871414

    And check that there isn't a job somewhere that runs shrink on a regular basis

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 16, 2008 at 6:36 am

    #872309

    The autoshrink option was set to 'true', when we turned in off ('false') it worked.

    Thanks everyone for your help.

    Ben

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

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