Adding new data file

  • I have a database of 160 GB. There is no moe space to grow on the same drive.

    I have 80 GB space on another drive. I will make a new .NDF on the same file group and stop the autogrow on the .mdf file and allow autogrow on the new .NDF file.

    Will it work fine? you have any better solution to this problem?

    Thanks in advance

  • Yes, you are heading into right direction. It will work.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Go ahead all the best

  • yep it will .

    Regards

    sat

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

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