September 17, 2009 at 5:39 am
i have a large database (127GB) in a single mdf file which i would like to split into several ndfs. what's the best way to go about this?
i'm considering backing up the databse, dropping the database, recreating the database with multiple ndfs, and then restore. (i presume this would work!)
is there an easier way?
a side question: when i do the restore above, how will SQLServer fill the ndfs? does is stripe database across them somehow, or does it fill the mdf first, then fill the next next ndf, etc.
September 17, 2009 at 5:57 am
DBAJAY (9/17/2009)
i'm considering backing up the databse, dropping the database, recreating the database with multiple ndfs, and then restore. (i presume this would work!)
No, this would not work. You need to create additional files into new filegroups and then manually move your tables/indexes into those files.
If there is a clustered index on the table, recreating the clustered index into the new file would move the base table.
if there is no clustered index, then you need to create on in the new filegroup and then delete this newly created index.
September 17, 2009 at 6:37 am
well poop, you're right. i just tried an experiment on a test server and it just deleted the ndfs and restored into one big mdf again. i guess i gotta do it the hard way then...:crazy:
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply