Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

move all indexes to a secondary file group Expand / Collapse
Author
Message
Posted Wednesday, January 2, 2013 7:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 30, 2014 6:20 AM
Points: 6, Visits: 52
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
Posted Wednesday, January 2, 2013 9:09 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, July 26, 2014 7:26 PM
Points: 182, Visits: 151
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 »

Add to briefcase ««12

Permissions Expand / Collapse