SELECT

[Current LSN],

[Operation],

[Transaction ID],

[Description], SPID,[Begin Time], [Transaction SID],

name 'LoginName'

FROM fn_dblog (NULL, NULL),

(select sid,name from sys.syslogins) sl

where [Transaction Name] LIKE '%delete%' and [Transaction SID] = sl.sid

this query is not showing...

Hi,

when secondary DB is put in norecovery mode and log backup happening at every 1 minute. So, restoring happening continuosly and that is the reason you were seeing such...