Post reply

What happens if I drop staging table after switching the partition to a table

  • August 7, 2010 at 9:22 pm

    #224389

    After switching a partition to a staging table, we take backup of the data in staging table using BCP and then we drop the staging table.

    What will happen to the partition if we drop the staging table like this? Will the partition still be there?

  • August 8, 2010 at 9:10 am

    #1203934

    praveen_vejandla (8/7/2010)

    After switching a partition to a staging table, we take backup of the data in staging table using BCP and then we drop the staging table.

    What will happen to the partition if we drop the staging table like this? Will the partition still be there?

    My personal policy is always to test those things and not rely on third party advice from people that would not lose their jobs if it fails.

    Either way, you have already switched the partition meaning data that was in the STG table is not sitting pretty as a partition of the core table so... if you drop STG table STG table will go to table's heaven and partition will stay here.

    Hope this helps.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • August 11, 2010 at 12:14 am

    #1205161

    Thanks.

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

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