hi, we have a database in simple recovery mode
if a table were dropped
Is there a way to recover the dropped table
thanks
DaveL
if a table were dropped
Is there a way to recover the dropped table
thanks
DaveL
-
-
Re: dropped tables
SqlSErver 2005, windows 2003 server
Sql is in Simple Recovery Model
"DaveL" <dvs_bis@sbcglo bal.netwrote in message
news:klook.2281 5$Ri.15262@flpi 146.ffdc.sbc.co m...hi, we have a database in simple recovery mode
if a table were dropped
Is there a way to recover the dropped table
>
thanks
DaveL
>
>
-
Re: dropped tables
DaveL (dvs_bis@sbcglo bal.net) writes:Restore it from a backup if you have one. Else... if you are lucky thehi, we have a database in simple recovery mode
if a table were dropped
Is there a way to recover the dropped table
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@sommarsk og.se
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at
Comment
-
Re: dropped tables
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@sommars kog.sewrote in message
news:Xns9AF9605 84E680Yazorman@ 127.0.0.1...DaveL (dvs_bis@sbcglo bal.net) 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@sommarsk og.se
>
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Comment
-
Re: dropped tables
DaveL (dvs_bis@sbcglo bal.net) writes:Maybe time to consider to switch to full recovery?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
--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
Comment
Comment