move all indexes to a secondary file group

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by michael vessey » move all indexes to a secondary file group

12 posts, Page 2 of 2

««1 2

move all indexes to a secondary file group

Rate Topic

Display Mode

Topic Options

Author

Message

Arju

Posted Wednesday, January 02, 2013 7:26 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 10:24 PM
Points: 5, Visits: 35

Hi,

Can some one provide links to move tables & indexes to other file group without drop & Recreate them.

Just like to move object to other file group without drop and recreate.

Thanks

Post #1401830

Ryan McCauley

Posted Wednesday, January 02, 2013 9:09 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:15 PM
Points: 181, Visits: 140

To do this, you have to create a clustered index on the table and specify the new file group for the index - once you've moved it, you can drop the index if you don't need it. Effectively, you'd use this same script, but you'd remove the filter that causes it to ignore clustered indexes so that it migrates those as well.

Ryan

Post #1401901

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions