recovering deleted table

Hi all
Is there a way to reconstruct a table which was deleted without restoring
the whole data base?
Database recovery model is simple. Sqlserver version is 2000 sp3.
TIA
ReaYou can restore the database from the backup to a different location with a
new name, and then copy the table with DTS from the restored database to
your production database.
--
Jacco Schalkwijk
SQL Server MVP
"Rea Peleg" <rea_p@.afek.co.il> wrote in message
news:eys9$rjQEHA.2132@.TK2MSFTNGP11.phx.gbl...
> Hi all
> Is there a way to reconstruct a table which was deleted without restoring
> the whole data base?
> Database recovery model is simple. Sqlserver version is 2000 sp3.
> TIA
> Rea
>|||The restore you do could also be a partial restore if you have the database
in multiple files ( See Restore in BOL).
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
news:OIJuPzjQEHA.1388@.TK2MSFTNGP09.phx.gbl...
> You can restore the database from the backup to a different location with
a
> new name, and then copy the table with DTS from the restored database to
> your production database.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Rea Peleg" <rea_p@.afek.co.il> wrote in message
> news:eys9$rjQEHA.2132@.TK2MSFTNGP11.phx.gbl...
> > Hi all
> > Is there a way to reconstruct a table which was deleted without
restoring
> > the whole data base?
> > Database recovery model is simple. Sqlserver version is 2000 sp3.
> > TIA
> > Rea
> >
> >
>