Restore 2 Tables From FULL BACKUP

  • Hi

    I had a Full Backup of the Database 'CustRep'

    i took the backup at 10 am after 1 hour, 2 tables data gone lost in the database, i want to restore the 2 tables from my backup, i don't want to restore the whole database, i don't want to restore as a new database and restore the 2 tables from that new database, i want to restore directly to the database only 2 tables, how can i do that?

    if any one know about this please let me know..

  • Unfortunately that's not possible. Ultimately your best bet from what you have described is to restore to another "mock" database and copy tables back over.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

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

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