Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

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

share|improve this answer
If your running SQL 2005 or earlier lightspeed will also compress your backups very nicely. its a great product – JoshBerke May 1 '09 at 15:04

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?

share|improve this answer
+1 for finding SO link. – Sung May 1 '09 at 15:51

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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