SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Restore field from backup?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

125 Posts

Posted - 12/13/2011 :  19:22:32  Show Profile  Reply with Quote
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?


Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 12/14/2011 :  04:13:10  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000