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?
+11
A:
Restore the whole database to another machine (or temporary database), then copy the table seems like the easiest to me.
le dorfier
2008-11-18 00:05:36
This is correct. There is no partial restore functionality in SQL Server.
Chris
2008-11-18 00:06:34
Huh! Well, learn something new every day. This worked great, by the way. (minor) crisis averted. Thanks!
Electrons_Ahoy
2008-11-18 00:24:06
+1
A:
The unit of backup and recovery in SQL Server is the database (it is the outer boundary of referential integrity).
Red Gate has some pretty good tools for row-level restore (SQL Data Compare and SQL Backup), but they come at a price.
Cade Roux
2008-11-18 01:11:12