Post reply

Restore table

  • April 11, 2008 at 3:39 pm

    #121133

    Hi All,

    I have backup of xyz database (xyz.bak). I want to restore auditing table from my xyz.bak file to another server. In directly I mean I want to restore only one table from my backup. Could anyone please help me to perform this activity.

    Urgent help would be appriciable..

    Regards,

    Austin

  • April 11, 2008 at 4:02 pm

    #801741

    no direct way to do this from a sql backup. common method is to restore the .bak file to a database with a different name then copy the table you requie over to original database using bcp or dts or select.

    ---------------------------------------------------------------------

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

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