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
- 12858 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's the information that can be stored inside a bit column? : Sql server database administration
How to invoke a trigger on demand?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What is your recommendation for a query running very slow? : sql server database administration
What is the tcp/ip port on which sql server runs?
What is the use of nvl work?
What is explicit mode in sql server?
What are the difference between “where” and “having” clause in sql server?
What does man by sql wildcard characters in sql server?
How much is a sql server license?
How do you check sql server is up and running?
Explain the working of sql privileges?
How to drop existing indexes in ms sql server?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What is tempdb database? : SQL Server Architecture
