Its not possible to restore single table unless your table is on a particular file group. But there are 3rd party tools that can do this.

-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x17997838.[Email address protected]
Sent: Thursday, December 28, 2006 5:28 PM
To: LazyDBA Discussion
Subject: RE: Restoring a particular table from a dump file


Oh my! Phew! Ouch! Are you saying SQL Server doesn't have a recycle
bin or an export/import command like Oracle? Hehe.





Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Harsh Kumar
[mailto:mssqldba-ezmlmshield-x59746164.[Email address protected]
Sent: Thursday, December 28, 2006 7:00 AM
To: LazyDBA Discussion
Subject: RE: Restoring a particular table from a dump file

Ya make dump table in particular file group and then backup this file
group
only.

-----Original Message-----
From: Sampathkumar Bodiga
[mailto:mssqldba-ezmlmshield-x79052144.[Email address protected]
Sent: Thursday, December 28, 2006 4:09 PM
To: LazyDBA Discussion
Subject: Restoring a particular table from a dump file

Hi Gurus
Wish you all a happy new year
can anybody give me details on how to restore a single table from a
database dmp file

Thanks
sampath kumar bodiga.


______________________________________________________________________


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

MS Sql Server LazyDBA home page