September 5, 2007 at 6:41 am
Is there a way to move a previously created file to a new filegroup. I've taken over administration of an installation. The previous dba created 5 new files all utilising the primary filegroup; all on the same physical disk.
I've been tasked with moving or modifying these additional files and assigning them to 5 different filegroups. I have never encountered this type of task before; and to be honest I don't think it is possible. Other than creating new files for each of the filegroups.
September 5, 2007 at 7:18 am
I don't think your task is as simple as you hope. With the five files you have, you have no way of specifying what data goes on what file. When you split your five files into their own filegroups, you will then have to decide what data goes in what filegroup. The simplest thing for you to do, I think, is to create five new filegroups and then distribute your data amongst them as you see fit. That will leave you with the PRIMARY filegroup holding the system tables. I'm not sure whether it's possible to delete any of the files in that filegroup, but give it a go (back up your database first).
John
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply