November 19, 2008 at 10:26 am
Hi everyone,
I have an issue regarding the secondary filegroups which we added for one of our database.
when we try to move the data and index files with the specified filegroups, what we can see is the data files are getting stored on the place where the indexes are suppose to be.
We are trying to figure out the issue.
Right now we are using Sql Server 2005 Standard Edition with SP2.
What we are thinking is may be the standard edition has this problem ???
Thanks In Advance,
Bhagya
November 19, 2008 at 10:46 am
Post the DDL for the tables and indexes. Can't really tell what the issue is based solely on your post. Also, post the DDL for the database as well so we can see the file groups associated with the database.
November 19, 2008 at 11:05 am
When you move a clustered index to different filegroup,that means the table is moved .sp_help 'tablename' will show you that the data is located on secondary filegroup.
Moving clustered index means moving the Table.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply