469,935 Members | 1,924 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,935 developers. It's quick & easy.

dropped tables

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
Aug 12 '08 #1
4 3281
SqlSErver 2005, windows 2003 server
Sql is in Simple Recovery Model

"DaveL" <dv*****@sbcglobal.netwrote in message
news:kl******************@flpi146.ffdc.sbc.com...
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


Aug 12 '08 #2
DaveL (dv*****@sbcglobal.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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 13 '08 #3
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" <es****@sommarskog.sewrote in message
news:Xn**********************@127.0.0.1...
DaveL (dv*****@sbcglobal.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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Aug 15 '08 #4
DaveL (dv*****@sbcglobal.net) writes:
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
Maybe time to consider to switch to full recovery?

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.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

Aug 15 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Al Murry | last post: by
3 posts views Thread by hikums | last post: by
1 post views Thread by Ravi Padmakar | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.