>In SQL Server 2000, is it possible to tell autogrow to happen during a particular period of time (after normal office hours for example) rather then when ever it wants? I'm assuming it detects the need to grow, and just does it rather than detects and schedules.
>
>Thanks
>
>Kirk
I don't think so, and I think you might be prematurely optimizing this. IMO, you should wait until there is evidence of a performance issue, and then manually set the size to a high number at that point.