restore single table from backup

Hi,
I'm looking for tool that would allow me to restore a single table from a ba
ckup without restoring full database... I tried lumigent software but it did
not work as I expected...
Thank you for your help
Darekhi derek,
Im not sure about 3rd party tool. but with SQL Server, you can not restore a
single table out of backup. You can restore the database to a different SQL
Server, or if you are using same Server, then restore it with the different
database name and transfer the required table using DTS/bcp etc to destinati
on.
-- Vishal|||Read a while ago that CA has a tool to do this among others. You may check
with them. Of course in restoring a table (if you can) you always need to
watch out data integrity issues.
"Darek" <anonymous@.discussions.microsoft.com> wrote in message
news:CD4CFA7D-85A3-4D71-8524-EB3834C92123@.microsoft.com...

quote:

---

> Hi,
> I'm looking for tool that would allow me to restore a single table from a

---

backup without restoring full database... I tried lumigent software but it
did not work as I expected...

quote:

---

> Thank you for your help
> Darek

---

|||Hi,
SQL server versions which is higher than 6.5 will not support table level
restore, Only Filegroup / full database restore is available in SQL 7 and
2000.
Thanks
Hari
MCDBA
"Darek" <anonymous@.discussions.microsoft.com> wrote in message
news:CD4CFA7D-85A3-4D71-8524-EB3834C92123@.microsoft.com...

quote:

---

> Hi,
> I'm looking for tool that would allow me to restore a single table from a

---

backup without restoring full database... I tried lumigent software but it
did not work as I expected...

quote:

---

> Thank you for your help
> Darek

---

sql