• You have to assign the new file to a different logical filegroup in the database, otherwise you can't control it.

    Once you have done that, you rebuild the clustered index in the new filegroup. You'll be making the table unavailable during this process.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA