July 29, 2011 at 2:34 pm
Hi,
I have a database of 60GB+ with only 1 datafile :doze:. How I can create new datafile and spread the data among them, if it doable?
My database sit on an array RAID10.
Thanks
July 29, 2011 at 2:41 pm
just add a file to the filegroup. SQL will automatically start writing to the new file. It writes in a round robin proportional fill basis., i.e it writes more to the emptier file in an attempt to even up the empty space in the files.
alternatively add a new filegroup. In this case though you will have to explicitly move data to the new filegroup, by dropping and recreating the clustered index in the case of the actual data, and by dropping and recreating non clustered indexes. You just use the ON filgroupname clause in the create statement.
which objects are best to move depends on your data and how it is queried\updated.
---------------------------------------------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply