Hi,
Is it possible to get back the database table after successful execution of delete command?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin MorePosted Oct 23, 2011, 2:13 PM
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 MorePosted Oct 23, 2011, 2:11 PM
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 NayakPosted Oct 23, 2011, 1:10 PM
Please elaborate your question.
Thanks