Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

3 Answers

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
add comment

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
add comment

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
add comment

Your Answer

 
discard

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.