Post reply

log file size

  • December 9, 2002 at 8:45 am

    #63229

    I am using SQL Server 2000. The log file size of a database is initially allocated very big. I can shrink the file, but it goes back every time when a weekly optimization job or server reboot is applied. So I have to manually shrink the log file again.

    Can anyone advise me how to avoid this problem?

    Thanks

  • December 9, 2002 at 8:50 am

    #443772

    Turn "autogrow" off for your log file. Your data base activity will stop when the log fills up. You will need to create an automated process to back it up when it gets full. OTherwise, I'd look for an office without a phone.

  • December 9, 2002 at 9:57 am

    #443789

    Is it every time you reboot? So if you shrink and then reboot, does it immediately grow?

    You might also try detaching the db, then reattaching with no log. Do a backup first.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

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

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