Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Restoring a single table from a backup 1

Status
Not open for further replies.

gibson153

Technical User
Jul 20, 2001
29
US
Is it possible to restore a single table from a backup? If so how?

thanks

david David

 
In sql versions 7 and above, no. Your best bet (if you have enought disk space) is to restore the entire database under another name and then copy the problem table to the original database.

In, 6.5 you could restore a single table only if it had no text or image fields.



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top