It used to in 6.5.... ;)

Meaning that in 6.5 you could do table level restores. They took it out
in 7.0 and onward, sadly.


Easiest is to restore the full backup as a different database name and
then move the table from the restored-to db into the original db.

-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x17997838.[Email address protected]
Sent: Thursday, December 28, 2006 3:58 AM
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




------------------------------------------------------------------------------
NOTICE OF CONFIDENTIALITY
The information contained in this communication and any accompanying document(s) is proprietary and confidential and is intended solely for the above-named individual or entity. If you are not the intended receiver, recipient or entity, you are advised that any distribution, copying, disclosure or communication of this email is strictly prohibited. If you have received this email in error, please contact me at the telephone number listed above or 858.716.1500.
==============================================================================


MS Sql Server LazyDBA home page