Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

This question already has an answer here:

on SQL Server 2005, we do a weekly full backup with nightly incremental backups.

I want to know if it is possible to restore a single table from a backup, either to the source database or a different one.

I can not find any clear answer online.

Thanks in advance.

share|improve this question

marked as duplicate by Jon Seigel, Mark Storey-Smith, RolandoMySQLDBA, dezso, Marian Feb 11 '13 at 16:04

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

3 Answers 3

up vote 4 down vote accepted

You can't restore a single table directly from your backup to a database.

You could restore your complete backup to new database and then copy your table from there to the desired database.

share|improve this answer
3  
Another alternative is to use third party tools, such as Red Gate SQL Backup, Quest LiteSpeed, or Idera SQL Safe, which all allow you to perform object level restores using native SQL backups. –  Mike Fal Feb 8 '13 at 5:14
    
I went with this, simple and easy, and no disruption to the production db or the other tables which were not affected. –  robarwebservices Feb 20 '13 at 0:44

You can also try some of the 3rd party tools that allow you to attach database backups and work with them as with live databases. You can try SQL Virtual Restore from Red Gate or ApexSQL Restore from ApexSQL or SQL Virtual Database from Idera.

All of these are commercial tools but you can find fully functional trials to get the job done. Additional benefit of all of these is that they require very little additional space unlike standard backup restore.

Sorry for the lack of links to all tools but I can't post more than one link due to low reputation :)

share|improve this answer

There is another method, but a little more complex. If your single table is getting very large, copy it onto a filegroup. Then use File & Filegroups backup to restore the single table.

See also : http://msdn.microsoft.com/en-us/library/ms177425.aspx

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.