Restoring a table

  • Is there any way to restore a table from a backup? If not, is there any way to copy the table from the restored database to the original database when the original table still exists?

  • I can't answer the restore straight from a backup question but you can surely restore the backed up database to one with a new name and then copy the contents of the table in the restored database to another database.

    See Books On Line topic How to restore a database backup for restoring method

    You can use straight SQL to copy the data from the backup to current table using Truncate then Insert. You will probably want to recreate statistics on the table when the restore is done.

    If you prefer you can also do the copy of data using the Export service in Enterprise Manager. Pick the server, expand databases, select your backup db, expand tables, select the table you want then do ALL Tasks and Export. This will allow you to enter source and destination server/DB and tables. Then run the job.

    Good luck'

    Toni

  • Not with the native SQL backup/restore. I know litespeed can restore a single table from a backup. It's a time-intensive operation on a larger DB, but it can be done. Possibly some of the other 3rd party backup tools have similar functionality.

    You can restore your db onto the server without over writing the one that's there, then insert/update from the table in the restored backup to the original DB. Or you could do the same across server.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • you can use redgate tools to do that. tools like sqlcompare can do that for u which checks for data changed and then change only those rows

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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