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
- 12724 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 will be query used to get the list of triggers in a database?
What is the cartesian product of table?
What is the difference RDBMS and Graph Database?
What is partition index in sql server?
How can I know what locks are running on which resource?
How to run queries with sql server management studio express?
What is a document index?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
Does partitioning ssd reduce performance?
What is SQL Azure Fabric?
What are the properties of the relational tables?
Can an automatic recovery be initiated by a user?
Can sql server be linked with other servers like oracle?
How many types of schemas are there?
