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. thanx,hope 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. thanx,hope you will get answer. Pravin. (Mark "Accepted answer" if this post helped you)

Satyapriya Nayak · Answer

Hi Deepak, Please elaborate your question. Thanks

Back up of Database table after delete command

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)