InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 16:24:06 GMT20http://www.sqlservercentral.com/Forums/Topic412556-24-1.aspxAndras, I have downloaded the tool . It works fine. It is a very nice tool and very userfriendly. I could retrive certain tables but not all the tables. Anyhow thanks a lot for you ..Tue, 23 Oct 2007 07:00:04 GMTselvisirumalar.mariasusaihttp://www.sqlservercentral.com/Forums/Topic412556-24-1.aspxDear Andras, I have downloaded the tool. It works fine. Really such a nice tool and very user friendly also. So so thanks. I was able to recover certain tables but not all the tables . Anyhow thanks a lot. Tue, 23 Oct 2007 06:58:17 GMTselvisirumalar.mariasusaihttp://www.sqlservercentral.com/Forums/Topic412556-24-1.aspxHave a look at Red Gate's SQL Log Rescue. It will restore your table based on the transaction log and earlier backups. It is a free tool and it works with 2000 only.Disclaimer: I work for Red Gate, and I wrote the engine of the tool in question.Regards, AndrasFri, 19 Oct 2007 03:43:10 GMTAndras Belokosztolszkihttp://www.sqlservercentral.com/Forums/Topic412556-24-1.aspxHi , Thanks for your reply . But I couldn't articulate the following line of yours. " Restore your db to a copy - make sure you don't overwrite your mdf and ldf - from a backup that has the table you're after. " I dont have any latest back up of my db.. Is it possible to do something with the transaction log .. regardsM.Malar. Fri, 19 Oct 2007 02:35:08 GMTselvisirumalar.mariasusaihttp://www.sqlservercentral.com/Forums/Topic412556-24-1.aspxThe easiest way of restoring a database is by means of using database publishing wizard. The feature of using this wizard, is it will carry both schema & data of all the objects of a particular database. Provided, if you have the very latest script file of this, you can do so.Thu, 18 Oct 2007 23:54:08 GMTVSVaidyahttp://www.sqlservercentral.com/Forums/Topic412556-24-1.aspxYou can do flashback in Oracle, not sql.Restore your db to a copy - make sure you don't overwrite your mdf and ldf - from a backup that has the table you're after.Then create the table structure on your db (CREATE TABLE...)Then run INSERT INTO your_db.dbo.tblname SELECT * FROM copy_db.dbo.tblnameCheck and drop the copy_db.You restore from a backup only the whole db, not separate object within.Good luckThu, 18 Oct 2007 23:19:16 GMTmichaelahttp://www.sqlservercentral.com/Forums/Topic412556-24-1.aspxHi , Accidentally a script deleted certain tables in my sql server database. Is there any means by which I can restore the table data. I used the command "FLASHBACK TABLE tcm_counter TO BEFORE DROP" but it is not working out. Please help me in restoring the table. Thu, 18 Oct 2007 22:54:52 GMTselvisirumalar.mariasusai