sql server back up : restoring data to one table

Question

Is there an easier way to restore data to single table in a sql server table rather taking down the database and restoring the entire database?

thank in advance

Answer 1

There is a third party product, LiteSpeed for SQL Server, which offers this capability of object and even row-level recovery.

Answer 2

You can restore the database from the backup file to another database name on the same server, or different server, then copy the data over.

If the database was Northwind, something like:

RESTORE DATABASE NorthwindTemporary
FROM DISK="D:\Backups\NorthwindBackup.bak"
WITH MOVE 'Northwind_Log' TO 'D:\SQL\NorthwindTemporary.ldf',
     MOVE 'Northwind_Data' TO 'D:\SQL\NorthwindTemporary.mdf'

StackOverflow: How do I restore a single table from a SQL Server 2005 backup?

Answer 3

SQL Server cannot do table-level backups or restores, although you can backup and restore files within a database if you want to

You're best bet is probably to restore the entire backup as a temporary database, and then copy the data you need over to the main database.

Tools like RedGate's SQL Data Compare are good for synchronising data.