Monday, February 20, 2012

Moving Indexes a different partition

Hi,
Does SQL Server has it own Index file?
How do we move the index from one partition to another, say, C TO D.
Thank You
Indexes are stored in the data files. If you just want to move a particular
index from drive C to D, you need to make sure that it's the only thing in
the data file(s). You can control what is in which data file(s) by specifying
which filegroup an index should be created on. Note that a filegroup has one
or more data files, and a data file must be in one and only one filegroup.
So one way to move an index from C to D is create a new filegroup with its
files on D, and then drop the index and re-create it on the new filegroup.
Look up CREATE INDEX in the Books Online for its detailed syntax.
Linchi
"loufuki@.gmail.com" wrote:

> Hi,
> Does SQL Server has it own Index file?
> How do we move the index from one partition to another, say, C TO D.
> Thank You
>
|||In addition to Linchi's answer , Indexes have pages not files. There are
data pages and index pages stored in data files
<loufuki@.gmail.com> wrote in message
news:b84a8468-2353-4e2e-9bb7-ac89db91c7b3@.q21g2000hsa.googlegroups.com...
> Hi,
> Does SQL Server has it own Index file?
> How do we move the index from one partition to another, say, C TO D.
> Thank You

No comments:

Post a Comment