Is there a way to restore one table from backup 1

[ksbigfoot]

It looks like our system is backed up Veritas on a tape drive.
Does anyone know if a single table can be restored from the Veritas system?

 

[mutley1]

Hey Bigfoot,

I can't speak for SQL 2005 as I have not used it at all yet, but if you are on 2000, NO. the only thing you can do is to restore the whole DB to ANOther db and copy the table across (select into statement or DTS export / import...whichever way you want to do it)

HTH,

M.

 

[ksbigfoot]

Howdy mutley1,

Thanks for the response.
What I ended up doing was this.
I had a test area that had almost all the data.
I copied the table (table1) to a different name in the test area (table2).
Imported that table over into my Production database.
Wrote a script that would take all the data from (table2) that was not already in (table1) and created a (table3).
I then appended through Microsoft access the table3 data into table1.
Seems like a weird way to do it, but that is the only way I know how to transfer data from table1 of the my test databases to table1 of my production database.

I gave you a star for letting me know that I couldn't retrieve just one table.

thanks again,
ksbigfoot

 

[mutley1]

Hey Bigfoot,

Thanks for the star. Unfortunately I have had no experience with Access to SQL so my advice will usually be how to on the SQL side!

Glad to have helped you learn somethnig though.

Cheers,

M.