Moving the index to different filegroup

There is already a database installed in my site and spilted on different fi
legroups. I want to know which object is located on which filegroup. prefera
bly the indexes and if I want to move them to another filegroup how can I do
.
Thanks in advance
Regards,
sunilHi,
Best approach is to drop and create the index in the new file group using
Create index command.
Please have a look into the below link for more information,
http://www.sqljunkies.com/HowTo/B9F...43A8681900.scuk
Thanks
Hari
MCDBA
"Sunil" <anonymous@.discussions.microsoft.com> wrote in message
news:7BA0A331-3990-4330-8837-9C871B24A9F4@.microsoft.com...

quote:

---

> There is already a database installed in my site and spilted on different

---

filegroups. I want to know which object is located on which filegroup.
preferably the indexes and if I want to move them to another filegroup how
can I do.

quote:

---

>
> Thanks in advance
> Regards,
> sunil

---

|||select
object_name(i.id) as table_name,
i.name as index_name,
groupname as [filegroup]
from sysfilegroups s, sysindexes i
where i.groupid = s.groupid
and i.name not like '_WA_Sys_%'
order by filegroup, table_name, index_name
Sunil wrote:

quote:

---

> There is already a database installed in my site and spilted on different
filegroups. I want to know which object is located on which filegroup. prefe
rably the indexes and if I want to move them to another filegroup how can I
do.
> Thanks in advance
> Regards,
> sunil

---