Re: recovering deleted table

From: Wayne Snyder (wsnyder_at_computeredservices.com)
Date: 05/25/04 

Date: Tue, 25 May 2004 06:55:46 -0400

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
> >
> >
>
>