move all indexes to a secondary file group

Total article views: 2598 | Views in the last 30 days: 65

 Rate this |   Join the discussion |  Briefcase

Move all (or chosen) standard indexes from your primary file group to a secondary file group (hopefully located on a seperate array)

excludes clustered indexes, statistics and indexes associated with a primary key

when you run it - set the debug to 1 to identify what the script will move, set it to 0 to actually perform the move.

the @rowcnt parameter will also allow you to specify the max number of rows in the index to move - I tried moving an index from a V V V large table (240Gb) and it took 2 hours.

Total article views: 2598 | Views in the last 30 days: 65