Sql Server 2005 - restore single table from backup

[samurrai]

I've got one table in a sql server database that was messed up during a recent update. I want to restore this table from an earlier backup. What is the easiest way to accomplish this?

Thank you!

 

[bborissov]

Create a new database
Restore that update into that NEW database.
Then Truncate the table in your database and finaly:

INSERT INTO YourDataBase.dbo.TableName
SELECT * FROM NewDataBase.dbo.TableName

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[samurrai]

Thank you. That was very helpful. I was able to sucessfully restore the table using the data from the backup.