recovering drop tables
-
is this possible guys
-
It's possible from a good backup, or within a transaction with Rollback 🙂
James.
-
As is the usual answer in the SQL Server world, it depends. You can use one of several log recovery tools (I know of ones from Red-Gate, Lumigent, and Apex), but their success rate can be dependent on recovery model selected and recent backups, in some cases. I'd look at those and see if they meet your needs.
If you're looking for a simple "UNDROP" type command, I'm afraid you're out of luck.
-
This is typically restore the database as a different name.
recreate your table in DB you dropped it from.
insert the records from the backup database to the recreated table.
You may have to turn identity insert on to maintain your relationships.
-
kewl
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply