InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 12:22:37 GMT20http://www.sqlservercentral.com/Forums/Topic1353981-146-1.aspxYou 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!Fri, 14 Sep 2012 09:03:40 GMTjql714http://www.sqlservercentral.com/Forums/Topic1353981-146-1.aspxis auto shrink turned on ? is there a dbcc shrinkfile/shrinkdb command being issues?Fri, 14 Sep 2012 08:04:07 GMTMVDBAhttp://www.sqlservercentral.com/Forums/Topic1353981-146-1.aspxI'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!Thu, 13 Sep 2012 16:16:11 GMTjql714http://www.sqlservercentral.com/Forums/Topic1353981-146-1.aspxThe ndf files are in the primary filegroup.Tue, 04 Sep 2012 10:49:28 GMTjql714http://www.sqlservercentral.com/Forums/Topic1353981-146-1.aspxwhere is your ndf is it on primary group or secondary?which is group is default?.Tue, 04 Sep 2012 10:20:02 GMTdurai nagarajanhttp://www.sqlservercentral.com/Forums/Topic1353981-146-1.aspxI need some help on resize a ndf file in SQL2000. Some of our databases have reached over 1TB. I've added ndf files to these databases. Since we don't have much room on the SAN, the initial sizes for these files are not that big. I've found that SQL distributed the new data based on the initial size. That means the mdf file is still loaded with the majority data. So hoping more data will be allocated to the ndf files, I've tried to increase the ndf file size however unsuccessful. Every time, it reverts back to its original size??? The script I've been using is:ALTER DATABASE myDBMODIFY FILE (NAME = myDB_ndf, SIZE = 200GB)GOCan somebody enlight me? I will be very grateful!:-)Tue, 04 Sep 2012 09:12:40 GMTjql714