All the data from all the partitions will be inserted into the new table (subject to your where conditions). But the new table will be created in the default partition. SELECT INTO construct cannot be used to create a partitioned table.
Thanks for your Reply. Normally when we install MS CRM , it creates partitions for AuditBase table. Normally it has some logs. These Logs are displayed in MSCRM GUI on 3 month partitioned basis.These logs can be deleted directly from CRM GUI, which will automatically clear all the contents from Database (MSCRM 2011) only support fastdelete unlike CRM 4.0 which supports softdelete.
As it is a Prod box, prior deleting the logs directly from GUI i have to take backup.
How can i take backup ?
So that if client wants to rollback then i can show him in GUI that logs have been created again and that too as it was earlier (In partitioned format)
The pictures you posted did not come through. Regardless, if you want to take a copy of a partitioned table, and you want to have the copy also be on corresponding partitions, you have to first create the new partitioned table and then copy into that.