We can only do the point in time recovery under Full or Bulk insert mode.
The row number 5 is gone after line 28 delete statement. Lets try to restore it.
First, we take another tran log backup
Then, lets restore with below orders:
- Full backup with no recovery
- Tran log 1 with no recovery and time stamp
- Tran log 2 with no recovery and time stamp
Since it is NORECOVERY, the database shows as Restoring…
STOPAT must follow by the time stamp where you want SQL Server stop applying the transaction log. Any log before that time (Including that time will not apply to the database)
In the production environment , if row being delete by accidently, it may not be a good idea to do this type of restore. As the database is not available during the time of restore. Most importantly, you will take a risk what if restore fail and you are losing the entire db. It is the best you can restore the database in the test environment and recover from there.