Can i increase an .mdf file without mofidying the 1 .nfd file in the database

  • HI,

    I have never worked with a database that has an mdf and ndf file. The mdf is autogrowing so i wanted to increase its size manually. But since i have never done this to a mdf file in a database that also has an ndf file, i wasn't sure if there were additional steps.

    Thank you


  • Sure, no problem. They are seperate files that can be grown (or shrunk) separately.

    Kind regards,

    Vegard Hagen
    Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
    @vegard_hagen on Twitter
    Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)

    It is better to light a candle than to curse the darkness. (Chinese proverb)
  • Thank you so much! exactly what i was hoping to hear!

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

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