Post reply

db autogrowth settings

  • January 10, 2012 at 7:23 am

    #1431135

    Yes.

  • January 10, 2012 at 7:25 am

    #1431141

    Unrestricted file growth will depend on whether your database shares the disk with other databases that may also want to grow. If it does, then it's wise to set a maximum growth for each file on the disk in case one of them suddenly grows and tries to consume the whole disk.

    John

  • January 10, 2012 at 8:30 am

    #1431206

    Thanks John that's an interesting point. The disk is shared with a read only copy of our production db(the one we've been discussing) that gets restored every early morning from the current backup. The disk is 350G with 73G used.

Viewing 3 posts - 16 through 17 (of 17 total)

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