January 18, 2008 at 11:18 am
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?
January 18, 2008 at 11:49 am
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
January 18, 2008 at 11:51 am
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
February 4, 2008 at 11:04 am
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