Re: dropped tables
- From: "DaveL" <dvs_bis@xxxxxxxxxxxxx>
- Date: Fri, 15 Aug 2008 09:01:18 -0700
We Restored from the last backup 12 hours prior...
and was able to rebuild the missing Rows , based on log entries....was a lot
of parsing and re-construction, but managed to get almost all re-built...so
were ok
thanks for all the advice
DaveL
"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns9AF960584E680Yazorman@xxxxxxxxxxxx
DaveL (dvs_bis@xxxxxxxxxxxxx) writes:
hi, we have a database in simple recovery mode
if a table were dropped
Is there a way to recover the dropped table
Restore it from a backup if you have one. Else... if you are lucky the
extents may not have been overwritten, so data can be recovered. Only
remains to find one who can do the work. I would start with opening a
case with Microsoft. So much is clear, this would be very expensive.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: dropped tables
- From: Erland Sommarskog
- Re: dropped tables
- References:
- dropped tables
- From: DaveL
- Re: dropped tables
- From: Erland Sommarskog
- dropped tables
- Prev by Date: Re: How to find out difference between two rows....
- Next by Date: plz suggest me the query
- Previous by thread: Re: dropped tables
- Next by thread: Re: dropped tables
- Index(es):
Relevant Pages
|
