Post reply

Unable to increase initial file size in SQL2000

  • September 4, 2012 at 10:20 am

    #1533384

    where is your ndf is it on primary group or secondary?

    which is group is default?.

    Regards
    Durai Nagarajan

  • September 4, 2012 at 10:49 am

    #1533401

    The ndf files are in the primary filegroup.

  • September 13, 2012 at 4:16 pm

    #1537553

    I've tried the second time using Enterprise Manager in SQL2000. It is executed successfully and the size is seemingly change. But it reverted back again the next day?!!

    Any suggestions or ideas? Thanks a lot!

  • September 14, 2012 at 8:04 am

    #1537846

    is auto shrink turned on ? is there a dbcc shrinkfile/shrinkdb command being issues?

    MVDBA

  • September 14, 2012 at 9:03 am

    #1537918

    You are right! The Autoshrink is on for the database. The developers creaeted these databases using their script. I did not create the database but I should have checked it.

    I will turn it off and try it again. Thanks so much!

Viewing 5 posts - 1 through 6 (of 6 total)

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