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

sql-server backup restore
Electrons_Ahoy picture Electrons_Ahoy · Nov 18, 2008 · Viewed 52.7k times · Source

I've got a backup made using the regular SQL Server 2005 backup command. Is there a way to restore just a single table, not the whole DB?

Answer

dkretz picture dkretz · Nov 18, 2008

Restore the whole database to another machine (or temporary database), then copy the table seems like the easiest to me.

Related questions

SQL Server: Database stuck in "Restoring" state

I backed up a database: BACKUP DATABASE MyDatabase TO DISK = 'MyDatabase.bak' WITH INIT --overwrite existing And then tried to restore it: RESTORE DATABASE MyDatabase FROM DISK = 'MyDatabase.bak' WITH REPLACE --force restore over specified database And now the database …

Read More
When restoring a backup, how do I disconnect all active connections?

My SQL Server 2005 doesn't restore a backup because of active connections. How can I force it?

Read More
SQL-Server: Is there a SQL script that I can use to determine the progress of a SQL Server backup or restore process?

When I backup or restore a database using MS SQL Server Management Studio, I get a visual indication of how far the process has progressed, and thus how much longer I still need to wait for it to finish. If …

Read More