Back up of Database table after delete command

Question

Hi Is it possible to get back the database table after successful execution of delete command?

Pravin More · Answer

Hi Deepak You mean to say you want deleted records of table....?? if so below are some posible solutions 1.Restore most recent backup under a different DB name. Import the records from that restored table. 2. or you can get it from transaction log for that you can try redgate.com they have a free tool that will read a SQL Server 2000 transaction log file (if your database is using the full or bulk-logged recovery model. thanxhope you will get answer. Pravin. (Mark Accepted answer if this post helped you)

Pravin More · Answer

Hi Deepak You mean to say you want deleted records of table....?? if so below are some posible solutions 1.Restore most recent backup under a different DB name. Import the records from that restored table. 2. or you can get it from transaction log for that you can try redgate.com they have a free tool that will read a SQL Server 2000 transaction log file (if your database is using the full or bulk-logged recovery model. thanxhope you will get answer. Pravin. (Mark Accepted answer if this post helped you)

Satyapriya Nayak · Answer

Hi Deepak Please elaborate your question. Thanks