Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup and Restore of a single table Expand / Collapse
Author
Message
Posted Friday, January 3, 2003 12:59 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 14, 2009 7:33 AM
Points: 112, Visits: 61
In SQL Server 6.5 version, it is possible to backup and load a single table from the backup of full dump file.

Do any DBA knows how to backup and load a single table?



Post #9083
Posted Sunday, January 5, 2003 6:09 PM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: Monday, October 20, 2014 1:24 PM
Points: 8,370, Visits: 743
No you can only restore the complete device to another location then export the data via bcp or other method to import into the original.




Post #50770
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse