question

Naren avatar image
Naren asked

rebuild index maintainance plane?

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?
sql-server-2005dba
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Yes while rebuild index maintainance plane running it was using current file group files. But I will create another file group I want to run rebuild inex run by using the new file group. So now onwards data is maintained in one file group and indexes are maintained in one file group... We have any chance to guide indexes to use another new file group?
0 Likes 0 ·

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
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.
4 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

You just have to drop and recreate the indexes on the new file group. There's now way to push them there during maintenance. Just move them.
1 Like 1 ·
Yes while rebuild index maintainance plane running it was using current file group files. But I will create another file group I want to run rebuild inex run by using the new file group. So now onwards data is maintained in one file group and indexes are maintained in one file group... We have any chance to guide indexes to use another new file group?
0 Likes 0 ·
This is what I was saying the last time @Naren asked this.
0 Likes 0 ·
Oh, haven't seen other questions from the same person this topic or I would have referred back to those. Sorry.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.