Recover Deleted Record in SQL Server

Question

I accidentally deleted a row in a table and want to restore it. I found a solution here: How to recover deleted records on MS SQL server

I tried to restore the database from a backup made after the deletion. But I can not restore the database with the STOPAT option:

RESTORE LOG database FROM  DISK = N'X:\database.BAK' WITH
STOPAT = N'2011-02-12T00:00:00', RECOVERY

I have the following error:

Msg 3117, Level 16, State 4, Line 1
The log or differential backup cannot be restored because no files are
ready to rollforward.
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.

Answer 1

I tried to restore the database from a backup made after the deletion.

You cannot restore deleted records from a backup made after delete. You need:

• last full backup made before deletion
• , , ,

, , .

, . , . , , , : . (Transact-SQL)

Answer 2

, , ApexSQL Log SQL Server, DBCC LOG fn_log.

:

SQL Server 2005?

SQL Server 2008

Answer 3

-

, , ​​ , . , , , . ( , , diff, ).

, , , , ? , .

Answer 4

, SQL Server , , , . SQL Server, .

, , . SQL .

: ApexSQL