Post reply

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

  • October 23, 2012 at 1:47 pm

    #263613

    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

  • October 23, 2012 at 2:00 pm

    #1552058

    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)

  • October 23, 2012 at 2:04 pm

    #1552060

    Thank you so much! exactly what i was hoping to hear!

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

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