Index moving to a new file group

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Index moving to a new file group

Author

Topic

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-05-07 : 13:18:29

I have a requirement for moving all the non-clustered indexes to a new file group. Does anyone have a script for this?

Thanks.

------------------------
I think, therefore I am - Rene Descartes

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-05-07 : 13:21:30

I got this link, http://www.sqlservercentral.com/scripts/Miscellaneous/31541/ does anyone have a better option?

------------------------
I think, therefore I am - Rene Descartes

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources