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

  • Juanita

    SSCertifiable

    Points: 5300

    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

    Juanita

  • Vegard Hagen

    Hall of Fame

    Points: 3078

    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)
  • Juanita

    SSCertifiable

    Points: 5300

    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