Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Restore field from backup?

Author  Topic 

taunt
Posting Yak Master

128 Posts

Posted - 2011-12-13 : 19:22:32
Hello is there a way one can restore a field from a backup of sql 2005? I need to do a restore of the sku in the items table where upc = 604988017724. The backup is in c:\sqlbackup\BU20111213.bak. Can it be done?

Thanks

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-12-14 : 04:13:10
Restore the entire backup as a new database and copy the data over.
Or, get a copy of RedGate's SQLVirtualRestore, mount the backup as a database and copy the data over.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -