Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Recover a Droped Table

Author  Topic 

JimAmigo
Posting Yak Master

119 Posts

Posted - 2005-07-20 : 11:41:45
Another individual in our office today deleted a table. Is there a way I can recover the deleted/dropped table without a recent backup?

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-07-20 : 11:49:28
no sorry.

Jim
Users <> Logic
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-07-20 : 12:03:44
if you are in FULL logging mode you have a chance to recover the table using lumigent log explorer (free evaulation download).

There is another similar tool from apexsql called apexsql log that might also work for you.



-ec
Go to Top of Page
   

- Advertisement -