Moving the index

Hello
Objective: move nonclustered index from one filegroup to another
Complication: index is large (>4Gb) and system can't be stopped
during this movement operation (CREATE INDEX WITH DROP
EXISTING will lock entire table). Allowed downtime - 1-2 mins.
Solution: unknown.
Serge ShakhovI don't think it can be done...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Serge Shakhov" <ACETYLENE@.mail.ru> wrote in message
news:67hhjb.bm9.ln@.proxyserver.ctd.mmk.chel.su...
> Hello
> Objective: move nonclustered index from one filegroup to another
> Complication: index is large (>4Gb) and system can't be stopped
> during this movement operation (CREATE INDEX WITH DROP
> EXISTING will lock entire table). Allowed downtime - 1-2 mins.
> Solution: unknown.
> Serge Shakhov
>
>