anyone help me out We have created rebuild maintainance plane for all user databases among them one database have two data file in same file group now I will create new file group and create one file in it now while running the rebuild maintainance plane need to create new indexs into new file group data file? So How we can modyfied the maintainace plane to use new file group for rebuild index for that database?
I'm confused. Are you saying that you want the rebuild to use the extra space during the rebuild process, but not at other times? No, you can't do that. Do you mean you want the indexes moved to the other file? Then just move the indexes.