Post reply

To place Index pages on different drive

  • October 13, 2006 at 9:35 am

    #192713

    I have a database with data pages and index pages on same data file drive.Now I want to move index pages on different drive and keep data pages on same drive.

    Please let me know how can I achieve this.

     

    Thanks,

    Sree

    Thanks,
    SR

  • October 13, 2006 at 10:15 am

    #665782

    Sree,

    Simplest and most straightforward way is to create a new filegroup on the new drive, script all your current indexes, drop the indexes and recreate them on the new filegroup.


    Thanks, and don't forget to Chuckle

  • October 13, 2006 at 12:00 pm

    #665811

    Thanks a lot for such a quick response Chuck.

    Could you please also let me know how do I specify that particular index needs to be created in particular file group or particular datafile?

    Thanks,

    Sree

     

     

    Thanks,
    SR

  • October 15, 2006 at 12:31 pm

    #665913

    Sree, I guess this is pretty common scenario...you can grab your MS book or BOL to find othe details... search for 'index'.. ATB..

    Get busy living ....or get busy dying....

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply