Does anyone know of any tools that can help in recovering dropped tables and stored procedures ?
There was no backup taken and this DB was accidentally synced up with another DB and the new tables created in this DB were dropped.
thanks
A:
i really dont think u can recover the table or its content if you had no backup ... anyway i wish i could be more helpful
Lil'Monkey
2009-08-20 15:32:45
ouch. i agree with this comment.
djangofan
2009-08-20 15:42:56
+3
A:
I googled "sql server restore dropped table" and came up with a helpful forum answer.
http://www.eggheadcafe.com/community/aspnet/13/11519/are-you-sure-you-dont-ha.aspx
"When a database is created in SQL Server, it is set to Full Back Up by default. So, your table should be available by restoring the transaction backup. Try going to the "restore database" options by right clicking on the database name in Enterprise Manager and selecting All Tasks."
I do question if that would restore the table or just the data, though.
There is some fairly low cost software by RedGate called "SQL Log Rescue" that is supposed to help with this. Check out this SQL Server Central article: http://www.sqlservercentral.com/articles/Product+Reviews/sqlrescuereview/2086/
EDIT: The RedGate software does require a full backup, so that won't help. I just caught that.
But perhaps the transaction log will help you in recovering the table structures, even if it can't actually restore the table itself.
sql_mommy
2009-08-20 15:37:11
really good points unfortunately as stated earlier he is supposed to have no backup ! still voting up for the detailled research gj !
Lil'Monkey
2009-08-20 16:35:45
thanks. :) Yeah - the RedGate software won't work since it requires a backup. However, if any transactions had been performed in the DB, there's a good possibility that the transaction logs still contain data that would help recover the table structure. If something isn't being backed up, you can usually assume that the defaults are being used when things are created, so the transaction log would have been logging.
sql_mommy
2009-08-20 17:16:44