Post reply

Export/Import

  • February 2, 2011 at 2:29 am

    #143233

    Dear All,

    One of my teammate deleted the rows in the table on production database.

    how to restore only particular table?

    I have backup for that db.If I restore that db in test environment, by using export wizard can I get the table with full structure i.e with constraints?

    Please advise.

    Thanks and Regards,

    Ravi

  • February 2, 2011 at 2:33 am

    #1281298

    you will need to restore to another server and then copy the missing data in the table from that server, a single table restore is not possible from a full backup without third-party tools.

  • February 2, 2011 at 3:31 am

    #1281319

    Thanks for your reply.

    I have restored the database in another server.

    By using export wizard, I have exported the table to old database but I couldn't see the indexes and constraints in the new table .

    Please advise how get the table entire structure( indexes and constraints) along with whole data.

    Regards,

    Ravi.

  • February 2, 2011 at 3:35 am

    #1281320

    when you script out the table on the restore server you need to select the option to script constraints and then use this script to create your destintion table.

    however I feel that this could be the wrong approach, as you stated that the user deleted rows of data in the table,

    so you should not need to recreate the tabe just use the existing table as your destination and copy the missing rows of data from your restore server..

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

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