January 3, 2005 at 1:42 am
Hi,
We have created all the user objects (table,sp's) in the primary file group(is the default file group).
Now we are planning to create two more datafiles (apps_data2,apps_data3) , a file group(filegroup_ext) and include these two files(apps_data2,apps_data3) in this filegroup (filegroup_ext) and make this as the default file group.
My question is, is it possible to move my existing objects in PRIMARY FILEGROUP to this newly created file goup(filegroup_ext) .
Please help me
Regards
SKV
January 3, 2005 at 11:45 am
You can move DATA and Indexes but not other objects like sp or views.
To move a table that has a clustered index on it simple Recreate the index using the ON part of the CREATE INDEX
if there is no Clustered index then create one to move it
The indexes should be located on the same FG than the data or else the backups will have to account for that
From that point on, the new tables can be created using the ON clause on the CREATE TABLE statement
HTH
* Noel
January 3, 2005 at 12:03 pm
If you need performance in your database, then consider placing the data and indexes on different filegroups which are on different drive arrays or LUNs. It makes the backup/restore process longer, but you will receive data faster as the reads are across multiple drives.
Another way to move a table or index is to use Enterprise Manager. (Not as efficient if there are large tables or clustered indexes involved). Choose the table and right click to find Design. Then click on the Properties icon...here you can change the filegroup the object is on.
Michelle
Michelle
January 4, 2005 at 6:30 am
Thanks a lot
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply