DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: autoextend on datafiles

  1. #11
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by slimdave
    So in that circumstance, there's no point setting a maxfile in the the database -- it's redundant, right?
    It all depends on where you want the error to be generated, but yes, either way you have a space problem. I take care of this problem by having monitoring software that knows how close the actual file size is to the maximum file size and determines when to add another data file.
    Jeff Hunter

  2. #12
    Join Date
    Jul 2003
    Posts
    323

    Cool Q for marist88 !!

    What monitoring software ? And can you desc. your env./os etc so that I can try to eval. it for my shop ?
    TIA,

  3. #13
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    home-grown as in "It works for me because I know how it works in my environment".
    Jeff Hunter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width