Interested to Buy Any Domain ? << Click Here >> for more details...
After using delete statement in sql query to delete some
records...to retrieve the deleted records we can get using
rollback command but till that where it stores means
particular location name i need....(after deleting and
rollback )
- 3 Answers
- 12979 Views
- CarrizalSoft Technologies, iGate, I also Faced
- E-Mail Answers
Answer Posted / imran
SQL Server keeps log for each deleted records. you can
query these logs via 'fn_dblog' sql server function.
Select [RowLog Contents 0] FROM sys.fn_dblog(NULL, NULL)
WHERE AllocUnitName = 'dbo.TableName' AND Context IN
( 'LCX_MARK_AS_GHOST', 'LCX_HEAP' ) AND Operation in
( 'LOP_DELETE_ROWS' )
But this log is in Hex format. and you need to convert this
Hex format to your actual data.
Given below is the article that can help you to recover the
deleted records in the same way defined above.
http://raresql.com/2011/10/22/how-to-recover-deleted-data-
from-sql-sever/
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the difference between Stored Procedures and triggers?
How can i Relate Tables in SSIS
What is primary key and example?
What is sql service broker?
What is normalization of database? What are its benefits?
What is tcl in sql server?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
What are the differences between web role and worker role?
Why use identity in sql server?
Can we install sql server 2016 on windows 7?
What do you mean by SQL injection attack?
How will you find out if there are expensive SQL statements running or not?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is the new security features added in sql server 2014? : sql server security
What do you understand by the analysis services in sql server?
