• Thanks GilaMonster for your reply.

    shall we create the new filegroup always at the time of partition creation throgh the job. is it the right thing to add the newfilegroups in the database ?

    We want to create the partition for the performenance prospects.