Post reply

selected table backup

  • September 9, 2009 at 5:19 am

    #137993

    Dear friends,

    Can we back up selected tables from a database in SQL Server 2005? I have a DB with 7 tables, among them 3 are encrypted. I need to backup only those 3 encrypted tables. Can I do that?

    Regards,

    Vicky

  • September 10, 2009 at 1:00 am

    #1051598

    Vicky (9/9/2009)

    Dear friends,

    Can we back up selected tables from a database in SQL Server 2005? I have a DB with 7 tables, among them 3 are encrypted. I need to backup only those 3 encrypted tables. Can I do that?

    Regards,

    Vicky

    No, you cannot take backup of selected tables.

    Instead, you can BCP out data of these tables in flat files OR create a blank database, import these tables and then take backup of this newly created database.


    Pradeep Singh

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

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