I 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 myDB
(NAME = myDB_ndf,
SIZE = 200GB)
Can somebody enlight me? I will be very grateful!:-)