Friday, March 23, 2012

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
Rea
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
>
|||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[vbcol=seagreen]
> 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...
restoring
>

No comments:

Post a Comment