Any possibility of recovering a deleted table
-
Hi Gurus,
One of my developer has mistakenly deleted a table which is not having any relation with the other tables in the database. Presently not having any backup plan in the existing server and as the data is crucial, trying to find the ways for recovering the table.
Any help would be highly appreciated.
Thanks in advance.
Lucky -
Ouch! No backup? Really? Too bad. You really need to have a backup to be able to recover.
One other POSSIBLE solution. Lumigent makes a product that can read the transaction log. You might be able to use that to find the data that was deleted. However, that would require your database to have been in FULL recovery mode.
Good luck.........
-SQLBill
-
I think Lumigen Log Explorer must be already installed.
You can't install it and read transactions written to the log before the installation.
I don0t think you would be able to recover the table.
-
You don't have backups, allow a developer to have such privileges...Do you also overclock your server?
Sorry, but I guess, you're pretty much out of luck.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
I think the only possibility is if you did an initial backup at some point in time (and still had it around)... and you had the database recovery mode set to full. Then you could run a transaction log backup. From this point, you could restore the original backup, then the transaction log to the point in time where the table was dropped.
I'm guessing you didn't run an original full database backup... so, I'm also guessing that you're just out of luck here.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply